Thanks, Greg! That line not only worked, but it gave me a more clear example of the structure of such queries. :)
-Mike > -----Original Message----- > From: Johnson, Gregert [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 20, 2002 12:56 PM > To: [EMAIL PROTECTED] > Subject: RE: Getting Data From One Table Based On Another - Agh! > > > 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 > --------------------------------------------------------------------- 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