In the section titled "Outer Join for a Simple Join to a Third Table",
the IDS Tutorial mentions the following example:
SELECT c.customer_num, c.lname, o.order_num, i.stock_num, i.manu_code,
i.quantity
FROM customer c, LEFT OUTER JOIN (orders o, items i)
WHERE c.customer_num = o.customer_num
AND o.order_num = i.order_num
AND manu_code IN ('KAR', 'SHM')
ORDER BY lname;
http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.sqlt.doc/sqlt96.htm
This example fails with syntax errors. The following, using the
Informix extension works fine:
SELECT c.customer_num, c.lname, o.order_num, i.stock_num, i.manu_code,
i.quantity
FROM customer c, OUTER (orders o, items i)
WHERE c.customer_num = o.customer_num
AND o.order_num = i.order_num
AND manu_code IN ('KAR', 'SHM')
ORDER BY lname;
Is it possible have a query that uses ANSI syntax to have a simple
join on two tables which is outer join-ed to a third table?
Thanks in advance.


|