Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Returning "Distinct" results from multiple tables
Wow, that Union does the trick... shame on me for not remembering its purpose :-P Thank you very much! -
Returning "Distinct" results from multiple tables
Well the best way of explaining I can think of is using an example... Let's say I have two tables: STORE_A_CUSTOMER_TRAN CUSTOMER_NO TRAN_TYPE_CD ... 111 Z ... 111 Z ... 222 Z ... ... STORE_B_CUSTOMER_TRAN CUSTOMER_NO...
