Re: MySQL Multiple Select Question
It sounds like your problem is related to how you arrived at the criteria for the data set.
You mention eid 100 then eid 103... what is the criteria that excludes eid's 101 & 102?
Once you can clarify that, you can build that into the query, most likely with a join and where clause conditions. You use a join when you are querying more than one table. You can also create a dataset as a temporary table, and use the temporary table to make your join. It all depends though on the how you arriving at the criteria within the data set.
Can you share that with us?
John
__________________
Peace
|