Hi,

I need simply to join 2 tables with join, where result is :
TB1 (ID1) - ID - index
1
2
3
TB2(ID2) - ID - index
4
5
6
select .... :
TB1.ID1 TB2.ID2
1 NULL
2 NULL
3 NULL
NULL 4
NULL 5
NULL 6
Any way to do it ?
Conditions :
NO SP, NO Union. (in real conditions and union and Sp is to slow
because of size of tables (>2.5mill records.))

--

Best Regards,
Adomas Urbanavicius