Oh! Ok. Thanx! Although I didn't really want to do all of that, I guess it's the only way. Unless someone has something better.
- Deryck Henson - http://www.sourcecodecafe.com ----- Original Message ----- From: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]> To: "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 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 --------------------------------------------------------------------- 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