> full join, which can be very inefficient. Much better to do
> a LEFT JOIN or an INNER JOIN if at all possible.
I'm pretty sure that you have to explicitly specify "FULL OUTER JOIN" if you
want a full join. If you just specify "JOIN", that's implicitly an INNER
JOIN.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
