You can use the table.field notation like: select * from cats, dogs where cats.owner = 'lisa' || dogs.owner = 'lisa'; select cats.food, dogs.owner from cats, dogs;
etc. etc. (note: '||' is the "or" logical operand) Good luck! -C -----Original Message----- From: Jessica Tishmack [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 2:53 PM To: [EMAIL PROTECTED] Subject: multiple tables with same fields Is there a way to select records from multiple tables that have the same fields, without doing a join? Basically, I want to merge two tables together, then do a select on the resulting table. But I want to do this without having to actually create a new merged table. Example: table pets1 name food owner fluffy purina kim fido kibbles lisa table pets2 name food owner snowy meowmix cheryl whiskers 9lives lisa Then I want to select all records from cats and dogs. Perhaps select all records from cats and dogs where owner is lisa...how would I do these two items? Thanks, Jessica --------------------------------------------------------------------- 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
