Yes, and reads from tables : count(tb1) * count(tb2) . no good.

Nick wrote:

>select * from table1 full join table2 on id1 = id2
>
>
>
>--
>Nick
>-----We Solve your Computer Problems---
>UNIX, C, Panther, Ingres, Interbase, Firebird - Available Shortly
>
>-----Original Message-----
>From: firebird-support@yahoogroups.com
>[mailto:firebird-support@yahoogroups.com] On Behalf Of Adomas Urbanavicius
>Sent: 31 March 2006 12:31
>To: firebird-support@yahoogroups.com
>Subject: [firebird-support] simple sql join ?
>
>
>
>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