Subject | Re: [firebird-support] Re: Natural Join |
---|---|
Author | Helen Borrie |
Post date | 2005-06-08T01:38:30Z |
At 06:09 PM 7/06/2005 -0300, you wrote:
Also, if your concept of natural join is the SQL standard one, that the
engine can pick up all columns in multiple tables that have matching column
identifiers and data types, and output an inner-joined set, then Firebird
doesn't support a natural join. Firebird also doesn't support the
idiosyncratic interpretation of natural join that is employed by Sybase and
MSSQL.
In Firebird joins, every column in every clause must be specifically
qualified, either by table/view name or by a table alias. Fb 2 is even
stricter: it won't let you mix table qualifiers and table aliases in the
same statement.
So, depending on how you define "natural join", Firebird never supported it
and is moving further and further from the idea of potentially doing so.
./heLen
>IIRC Bi-directional cursors will be suporteed on FB 2.0.No.
Also, if your concept of natural join is the SQL standard one, that the
engine can pick up all columns in multiple tables that have matching column
identifiers and data types, and output an inner-joined set, then Firebird
doesn't support a natural join. Firebird also doesn't support the
idiosyncratic interpretation of natural join that is employed by Sybase and
MSSQL.
In Firebird joins, every column in every clause must be specifically
qualified, either by table/view name or by a table alias. Fb 2 is even
stricter: it won't let you mix table qualifiers and table aliases in the
same statement.
So, depending on how you define "natural join", Firebird never supported it
and is moving further and further from the idea of potentially doing so.
./heLen