Alexandre Benson Smith wrote:

> An example:
> select * from A join B on (B.A = A.A) join C on (C.B = B.B)
> the join order could be
> A B C
> A C B
> B A C
> B C A
> C A B
> C B A
>
>

Oh My !

The SQL examples should join Table C to A and not B

select * from A join B on (B.A = A.A) join C on (C.C = A.C)

I am sure that I need some sleep...

sorry again....

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br