| Subject | RE: [firebird-support] what should i use where or join? whats the difference? |
|---|---|
| Author | Clay Shannon |
| Post date | 2005-12-05T15:33:03Z |
<<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
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