Re: Using UNION and UNION ALL on a database running 4.0

2001-11-04 Thread Deryck Henson
o: "Deryck Henson" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Saturday, November 03, 2001 7:37 PM Subject: Re: Using UNION and UNION ALL on a database running 4.0 > Hi, > > Try : > > SELECT * FROM tbl1 UNION ALL SELECT * FROM tbl2 UNION SE

Re: Using UNION and UNION ALL on a database running 4.0

2001-11-03 Thread Fournier Jocelyn [Presence-PC]
PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Sunday, November 04, 2001 2:26 AM Subject: Using UNION and UNION ALL on a database running 4.0 > Hi all, > > I have looked throught the manual and found that I could use a UNION syntax > to join a bunch of tables into

Using UNION and UNION ALL on a database running 4.0

2001-11-03 Thread Deryck Henson
Hi all, I have looked throught the manual and found that I could use a UNION syntax to join a bunch of tables into 1 query. How the heck can I do this with 15 tables, order the records by date_created desc and have there be WHERE title LIKE 'something'. I have those other parts (order, etc) jus