Hi, Try :
SELECT * FROM tbl1 UNION ALL SELECT * FROM tbl2 UNION SELECT * FROM tbl3 <cut> UNION SELECT * FROM tbl15 WHERE title LIKE 'something' ORDER BY date_created DESC Regards, Jocelyn Fournier Presence-PC ----- Original Message ----- From: "Deryck Henson" <[EMAIL 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 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) just need the union > syntax. here is my current non-working query: > > SELECT * FROM tbl1 UNION ALL WHERE title LIKE 'something' ORDER BY > date_created DESC > > Basicly, I want every single record in the database. Thanx ppl! And by the > way, the MySQL Manual is NO HELP AT ALL. too confusing and doesn't even > explain it fully. > > - Deryck Henson > - http://www.sourcecodecafe.com > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
