|
![](/i/fill.gif) |
"Darren New" <dne### [at] san rr com> 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
|
![](/i/fill.gif) |