Do not know if this is possible without creating temp tables or new tables, but basically I have a few tables that have similar fields
Table 1: lname
Table 2: lname
Table 3: lname
The tables are not the same, for instance all lname in T1 are not in T2, etc.
I want to be able to retrieve all the Distinct emails from the tables
For one table Select Distinct lname From t1...after that I am stumped on how to return just one column from all three tables...the lname is indexed so I am trying to avoid temp or new tables so I can then do quicker lookups to other fields other than from tables 1 through 3 ...
I guess I could do three seperate selects and place results in an array, but...
FWIW these items were all non-related to being with for the most part