I am also having difficulty getting to grips with the (awkward) join notation. In 3.0 how about support for Oracle type joins with (+) which seems far simpler to me :)
I oppose this.
Oracle's "(+)" was a nasty hack and I find it more difficult to understand than the "from a left join b on b.foo = a.foo" syntax.
The latter syntax is what most databases support, and it is what the ANSI/ISO SQL standard supports. If you want to be adding support for anything, it should be in the form that the SQL standards define.
And Oracle themselves have even seen the light and support that standard syntax in Oracle 9 and later (though not in 8 or earlier, unfortunately).
-- Darren Duncan
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
