Quote:
Originally Posted by ackerley1
hmmm... sorry for the late repsonse... was in the war path of Hurricane Dean when it made landfall in the Yucatan and Northern Belize...
Okay here is the structure:
Table 1: Name, email, IP, time and date stamps and the EID - which is unique.
Table 2: address, phone, comments, etc - each field has its own unique id, but also has the corresponding EID to the person who made the entry. So it could have up to 11 rows that correspond to 1 EID.
I know which EID's I want and and I really need nothing from Table 1 as I already have extracted that. I just need a way to get all the rows from Table two that correspond with specific EID's.
Thanks
|
So you don't say what the ID is that Table1 and Table2 have in common. Assuming it's customer_id for the sake of this example:
select table2.* from table1, table2 where table1.customer_id=table2.customer_id and x
where x is
table1.eid IN ('some','set','of','eid','values');
or
(table1.eid >= 'low value' and table1.eid <= 'high value');