Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>And is there any difference in functionality and/or speed between the above statement and ...
>>SELECT Table1.*
>>FROM Table1, Table2 ;
>>WHERE Table2.SeqNo=Table1.LinkField AND Table2.Id="123" ?
>
>I don't think so, but again, I have not done extensive testing. Except in situations that need an outer join, I still use the "WHERE" sytax to join tables, just out of habit.
Sometimes it is better to use the WHERE clasue esp. if you have to work against multiple databases. Oracle for example does not fully support ANSI-SQL92
and does not support Join conditions (it has its own syntax for left and right joins but that's another story)
Arnon
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement