Drew123
03-15-02, 10:12
| 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 :) |