Well, I'm not Ann... but...

> This is a question/request for incite/help. As tacky as it is, while I
> am looking for feedback from anyone, a reply from Ann Harrison would be
> appreciated.
>
> Currently, I and another developer seem to have a difference of opinion
> in the relevance and usefulness of implicit joins (SQL-89) and explicit
> joins (SQL-92). While we try and preach explicitly joining, if for any
> other reason, it is easier to read and follow, the differing developer
> insists that explicit joins are the way "Everyone does it".

Mixing both in the same query in Firebird can result in the wrong query
results. IMO, this is a bug, but it's the case.

In doubt and in other situations, always use SQL92 joins.

According to some, the optimizer does a better job with SQL92 joins
as well.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com