> What's the full SQL statement? Or at least a complete one with all
> the parts. Also, by using just "JOIN" in your statement, you're
> getting a full join, which can be very inefficient. Much better to do
> a LEFT JOIN or an INNER JOIN if at all possible.
The INNER keyword is entirely optional in SQL and its presence or
absence has no effect on the outcome.
Joined Table Syntax Rule 3:
"If a <qualified join> or <natural join> is specified and a <join
type> is not specified, then INNER is implicit."
(ISO/IEC 9075-2:2003, 7.7)
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
