Hi,
I have a database for a client that stores various types of items in
different tables, such as "demos", "movies", "patches" etc. Each of these
tables has several common fields: id (pk), datecreated and itemid (fk).
ItemID refers to another single table.
I need to somehow join these tables to return a list of the newest 20 items
added in the last 24 hours. That is, the newest twenty items overall across
the tables, not the latest 20 in each table. Is there a way to do this with
a single query?
Thanks for any help.
--
Rob Keniger
big bang solutions
<mailto:[EMAIL PROTECTED]>
<http://www.bigbang.net.au>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
