explicitly specifying it either way can hardly be considered a bad
thing.
cheers,
barneyb
On Sat, 28 Aug 2004 14:01:05 +0200, Jochem van Dieten
<[EMAIL PROTECTED]> wrote:
> Barney Boisvert wrote:
>
> > 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
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
