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