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,