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? Thanks, __________________________________ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/