| Subject | what should i use where or join? whats the difference? |
|---|---|
| Author | Fabio Gomes |
| Post date | 2005-12-05T15:24:12Z |
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? And what about speed? wich
one is faster?
Sorry if it sound stupid, but i never studied SQL, nor Firebird, i learned
all by myself, so i use what works, and both works, but i dont know how and
why it works.
Thanx for any help.
[Non-text portions of this message have been removed]
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? And what about speed? wich
one is faster?
Sorry if it sound stupid, but i never studied SQL, nor Firebird, i learned
all by myself, so i use what works, and both works, but i dont know how and
why it works.
Thanx for any help.
[Non-text portions of this message have been removed]