hi,
I have two tables:
table_1:
id_1
-----
1
2
3
table_2:
id_2
-----
3
4
5
I need to perform some kind of join to get the following result:
id_1 | id_2
-----------
1 |NULL
2 |NULL
3 |NULL
NULL |3
NULL |4
NULL |5
Someone told me i should use FULL OUTER JOIN, which didn't help me much, because there is no such join in MySQL (or is there ?)
Leszek
I have two tables:
table_1:
id_1
-----
1
2
3
table_2:
id_2
-----
3
4
5
I need to perform some kind of join to get the following result:
id_1 | id_2
-----------
1 |NULL
2 |NULL
3 |NULL
NULL |3
NULL |4
NULL |5
Someone told me i should use FULL OUTER JOIN, which didn't help me much, because there is no such join in MySQL (or is there ?)
Leszek