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