Discussion: Join vs ...
Afficher un message
Vieux 28/09/2007, 18h56   #1
pinkfloydhomer@gmail.com
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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

  Réponse avec citation
 
Page generated in 0,05789 seconds with 9 queries