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
|