poss in mysql?

[dreams4000]

Hi all,

I have a query that is joining a bundle of data from a couple of tables and returns a number of items as the result. one of the tables has an id number that is auto inc. I want to limit the results to the highest id # out of the results output. I have the query working fine if I want to display all of the results, but is there a way to say something like

WHERE table.id = "the highest of all the ids returned" without specifying a id # itself ? Thanks much!

[mrhappiness]

if it is only 1 record that can be returned to ORDER BY thecolumnyoustoreyouridin DESC LIMIT 1

[dreams4000]

I must be braindead not to remember that one.. Thanks so much for the help!! 🙂