Hi, Try :
SELECT table1.name,table1.position,table2.position FROM table1 LEFT JOIN table2 USING(name); Take a look here : http://www.mysql.com/doc/en/JOIN.html Regards, Jocelyn ----- Original Message ----- From: "Osman Omar" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Saturday, November 23, 2002 4:14 AM 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