Set,

>>
>
> I always think of it the opposite way, that is, in case of a LEFT JOIN that the LEFT (inner) table is taken first and then the RIGHT (outer) table.

We agree, except that I used "inner" and "outer" in the opposite sense - brain like body is on holiday.

Ann

>
> <commercial note>(if you need more than luck, try IBPhoenix)</commercial note>
>
>
> If you are on a tight schedule, have a large or critical system or want to be certain that the system will work properly, then it is of course worth considering using IB Phoenix right from the start, they do know everything worth knowing about Firebird.

Thank you!

Cheers,

Ann