----- Original Message -----
From: "Adomas Urbanavicius" <adomas@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, March 31, 2006 1:30 PM
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.))
I think something like:
select * from tbl1 full join tbl2 on tbl1.id = tbl2.id
might work...