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 ru

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

2002-12-10 Thread Angus Fraser
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 &

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 a