Wouldn't that give you every combination of rows from pets1 and pets2? The "union" operation is the construct that was designed for this type of thing. MySQL 3.x doesn't support it, but the MySQL 4.0 syntax will be:
select * from pets1 where owner='lisa' union select * from pets2 where owner='lisa'; Jon Gardiner. -----Original Message----- From: Chris Blessing [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 1:05 PM To: Jessica Tishmack; [EMAIL PROTECTED] Subject: RE: multiple tables with same fields Same thing still applies, just change the table names in the SQL I sent earlier. -C -----Original Message----- From: Jessica Tishmack [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 2:58 PM To: [EMAIL PROTECTED] Subject: Re: multiple tables with same fields > 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. err...I mean pets1 and pets2...not cats and dogs. --------------------------------------------------------------------- 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