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