Hi,
I thought this would be a classic sort of query but google did no give
me the answer.
I am attempting to select records where one of the dates is the latest
date before today
select max(date) from expo where date < now()
works for one record but other fields I need must be in aggregate or
grouped. Is there a simple SQL request to get the most recent records
from a set of joined tables?
TIA
Tony
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
