Subject OT Non-Firebird - braces as outer join escape sequence
Author Ann Harrison
I recently ran across this syntax. (Note {oj ...}


SELECT Customers.CustID, Customers.Name, Orders.OrderID, Orders.Status
FROM {oj Customers LEFT OUTER JOIN Orders ON Customers.CustID=Orders.CustID}
WHERE Orders.Status='OPEN'

It seems to be equivalent to


SELECT Customers.CustID, Customers.Name, Orders.OrderID, Orders.Status
FROM Customers LEFT OUTER JOIN Orders ON Customers.CustID=Orders.CustID
WHERE Orders.Status='OPEN'

Any idea what that's about and whether there's a difference between the two?

Ann