SELECT Table1.orderid, Table2.otherfield1, Table2.otherfield2 FROM Table1, Table2 WHERE Table1.orderid = Table2.orderid;
--Greg Johnson -----Original Message----- From: SpyProductions Support Team [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 12:31 PM To: [EMAIL PROTECTED] Subject: Getting Data From One Table Based On Another - Agh! Looking through the MySQL stuff online, I still can't come up with a statement to pull data from one table based on data from another. Table1 Contains: orderid Table2 Contains: orderid otherfield1 otherfield2 I want to get the data from table 2 based on a matching orderid first pulled from table1. Anyone have any ideas? Either this isn't able to be done, or I am (and I'm not) not advanced enough to understand the SQL statement needed. So far, I have tried a number of them that haven't worked. Any ideas? Thanks! -Mike --------------------------------------------------------------------- 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