View Single Post
  #18 (permalink)  
Old 08-26-2007, 11:56 PM
John Redfield John Redfield is offline
WebProWorld Member
 

Join Date: Jun 2006
Location: Third Stone from the Sun
Posts: 25
John Redfield RepRank 0
Default 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
Reply With Quote