it's work :) thanks all,
On Sun, 2002-11-24 at 12:28, Jocelyn Fournier wrote: > don't forget > > FROM table1,table2 ;) > : > > SELECT name, table1.position, table2.position > > FROM table1,table2 > WHERE table1.name=table2.name; > > Regards, > Jocelyn > ----- Original Message ----- > From: "Dennis Salguero" <[EMAIL PROTECTED]> > To: "Osman Omar" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> > Sent: Saturday, November 23, 2002 1:21 AM > Subject: Re: select from two table > > > > You might want to add some unique IDs or something else in common to make > > this query a bit better, but the following is what you should be doing: > > > > > > SELECT name, table1.position, table2.position > > WHERE table1.name=table2.name > > > > Good Luck! > > > > Dennis > > > > ----- Original Message ----- > > From: "Osman Omar" <[EMAIL PROTECTED]> > > To: "MySQL" <[EMAIL PROTECTED]> > > Sent: Friday, November 22, 2002 11:14 PM > > Subject: select from two table > > > > > > > I have 2 table with same structure > > > > > > table 1 have name and position > > > table 2 have name and position > > > > > > name in table 1 same as name in table 2 but position in table 1 may not > > > same as position in table 2 > > > > > > how do I get data like this > > > what is sql command > > > > > > name position.table1 position.table2 > > > > > > > > > thanks > > > > > > > > > > > > --------------------------------------------------------------------- > > > 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 > > > > > > > > > > -- *********************** Osman Omar SEM HA-QA Product Safety Section *********************** --------------------------------------------------------------------- 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