Subject RE: [firebird-support] what should i use where or join? whats the difference?
Author Clay Shannon
<<It can sound stupid, but i m newbie in this sql stuff.. i noticed that
something like:

WHERE X.field=Y.field

is the same as:

JOIN table X ON (X.field=Y.field)

Whats the difference? Wich should i use and why?>>

I'm no SQL expert, but:

I used to always use WHERE, now use JOIN where possible (pun joined to that
sentence unintentional), because JOIN is considered the (new?) standard way
of forming SQL st8ments.

Clay Shannon,
Dimension 4 Software