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 SELECT * FROM tbl3
cut UNION SELECT * FROM tbl15 WHERE title LIKE 'something' ORDER
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)
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 1 query. How the heck can I do this with
15
tables, order