IvorySQL icon indicating copy to clipboard operation
IvorySQL copied to clipboard

Oracle special outer join syntax not supported

Open haarse opened this issue 1 year ago • 0 comments

Enhancement

Oracle has a special syntax for outer join that is not supported in ivorySQL.

The syntax looks like this:

SELECT o.orderno, c.customername
FROM orders o, customer c
WHERE o.customerid = c.customerid (+);

This command is exactly the same as:

SELECT o.orderno, c.customername
FROM orders o
LEFT OUTER JOIN customer c
ON o.customerid = c.customerid;

It is possible to continue outer joins on more tables.

This is very common syntax in old Oracle applications and this is enhancement needed in order to migrate to ivorySQL for many such systems.

Ps. Thanks for your excellent work :-)

haarse avatar Aug 21 '24 07:08 haarse