Sorry, forgot :
No grouping, because of same reason. :)
Adomas Urbanavicius wrote:

>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.))
>
>
>

--

Pagarbiai / Best Regards,
Adomas Urbanavicius
+37068543336