Gail Shaw wrote:
> "Tom Austin" <taustin> wrote in message news:47b1ff01$1@news.povray.org...
> 
>> will it work if you remove the '*'?
>>
>> SELECT tbl1.Col1, tbl2.col2 from tbl1, tbl2 WHERE tbl1.Col1 = tbl2.Col1
>>
> 
> Sure. There's nothing in the syntax to say that's a join, not a where
> condition. It's the older outer join syntax that was deprecated and now
> doesn't work at all.
> 
> It's still recommended that joins be done in the from using the JOIN syntax.
> Makes it harder to do an accidental cross join. (2 or more tables 'joined'
> without a condition. Results in a cartesian product)
> 


So, using JOIN is more explicit - it requires a condition for the JOIN 
where just using a where clause does not?


Tom

Post a reply to this message