On dinsdag 2 december 2003 14:06 Director General: NEFACOMP told the butterflies: > Hi group, > > I want to do a LEFT JOIN that takes no condition. > > For example I have the following tables: > > table_1 table_2 > --------------- ----------------- > 1 A > 2 B > 3 C > 4 D > 5 E > > And I want my result to be: > > table_result > ----------------------- > 1 A > 2 B > 3 C > 4 D > 5 E > > > The result table has got two fields!! > By doing SELECT field_1, field_2 FROM table_1, table_2 I get > several records because it does a full join. > I want MySQL to just pick a record from table_1 and picks > another one from table_2 without a specified condition. > > > Which type of JOIN should I use? > >
use (..) FROM table_1 IMAGINARY JOIN table_2 ON table_1.getRowNumber() = table_2.getRowNumber() ... no, seriously ... a DBMS doesn't implement illogical things. :P, Wouter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]