General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only