Re: SELECT rows from multiple tables and order all by last added

2002-12-10 Thread Angus Fraser
the results of two queries? Thanks list for your patience. Angus - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 3:57 AM Subject: re: SELECT rows from multiple tables and order all by last added On Monday 09 December 2002 13:23

re: Re: SELECT rows from multiple tables and order all by last added

2002-12-10 Thread Egor Egorov
On Tuesday 10 December 2002 11:32, Angus Fraser wrote: Thankyou Egor Sorting by the auto_increment_column does return rows in the order they were added but I cant get it to do it for two tables. DATETIME or TIMESTAMP column contains the time row was inserted. UNION may work but I am

SELECT rows from multiple tables and order all by last added

2002-12-09 Thread Angus Fraser
Hi, I've joined this list today - looking for a good forum to discuss my difficulties with Mysql as they arise - I'm an SQL newbie. I'd like to construct a single query that creates one list of the contents of multiple tables (which all have a dateadded column) sorted so that output rows from

re: SELECT rows from multiple tables and order all by last added

2002-12-09 Thread Egor Egorov
On Monday 09 December 2002 13:23, Angus Fraser wrote: Hi, I've joined this list today - looking for a good forum to discuss my difficulties with Mysql as they arise - I'm an SQL newbie. I'd like to construct a single query that creates one list of the contents of multiple tables (which all