"Darren New" <dne### [at] sanrrcom> wrote in message 
news:4ae76041$1@news.povray.org...
> Captain Jack wrote:
>> Technically, in T-SQL, that would be a CROSS JOIN. JOIN all by itself 
>> defaults to a LEFT INNER JOIN, for which the results could vary.
>
> Actually, I thought you couldn't do JOIN all by itself at all. Every JOIN 
> has to be part of a SELECT, right?

Sorry... I meant to say "JOIN without a qualifier" rather than "JOIN all by 
itself". A JOIN clause always follows a FROM clause (essentially acting as a 
binary operator on two tables, creating a complex FROM) and the FROM has to 
follow a query directive like SELECT.

I always think of SQL as a weird language, but I guess English is a tad 
weirder. :D

Post a reply to this message