"Helen Borrie" <helebor@...> wrote in message
news:5.1.0.14.0.20020217154316.072ee1d0@......

>
> However, in a client/server production there are differences which will

affect performance. First, you would rarely use a query like your example
for fetching a dataset into your client application. You would limit the
rows returned with an "authentic" WHERE clause. So, in real life, the
implicit join clause would be a mixture of join criteria and authentic WHERE
criteria.

Furthermore, how do you express an outer join in a WHERE clause without
resorting to proprietary syntax? MsSql used
*=
and was deprecated in favor of authentic outer join syntax. IB never had
such proprietary construction, so the ANSI recommended way was the only way.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing