Subject | OT Non-Firebird - braces as outer join escape sequence |
---|---|
Author | Ann Harrison |
Post date | 2011-04-11T17:41:17Z |
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
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