Join vs ...
What's the difference between:
SELECT accountno, name
FROM accounts, customers
WHERE accounts.customerno = custommers.customerno;
and
SELECT accountno, name
FROM accounts INNER JOIN customers
ON accounts.customerno = custommers.customerno;
?
Are there any theoretical differences? Any practical differences?
/David
|