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