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