Reading the 'unsupported features page' there's a feature request about allowing
the + and - join syntax like oracle has. It would allow more easy readable and
writable queries although I know it's not quite standard. SQLite used to have
this (I read) but has been removed.
Albert Drent
I beg to differ.
I find having the join syntax in the FROM clause, which the SQL standard specifies, is a lot easier to understand.
The Oracle syntax is a lot more prone to human errors, especially when you have to add redundancy when relating either more than 2 tables or more than 1 column between a pair of tables; eg, you need to have more than one '+' just to specify a single join, or it won't work properly. You even need to put the '+' on non-joining terms like "foo = 'z'" where 'foo' is a field name in a joining table, or the join won't work correctly. What a pain.
Moreover, Oracle themselves have seen the light and support the SQL standard syntax in versions 9 and 10+.
Please leave things the way they are now, like standard SQL.
-- Darren Duncan
