View Single Post
  #11 (permalink)  
Old 08-24-2007, 04:36 PM
imvain2 imvain2 is offline
WebProWorld Pro
 

Join Date: Apr 2004
Posts: 283
imvain2 RepRank 0
Default Re: MySQL Multiple Select Question

I'm not sure if this is what you are looking for, but this combines table1 and table2's results based on matching the EID and it lets you provide multiple EIDs.

select * from table1,table2
where (table1.eid = 100
or table1.eid = 103
or table1.eid = 104
or table1.eid = 117
or table1.eid = 119
or table1.eid = 122)
and table1.eid = table2.eid
Reply With Quote