Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Informix > ANSI syntax for...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 14170 of 15119
Post > Topic >>

ANSI syntax for outer join

by Krishna <calvinkrishy@[EMAIL PROTECTED] > Jun 11, 2008 at 02:22 AM

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.
 




 2 Posts in Topic:
ANSI syntax for outer join
Krishna <calvinkrishy@  2008-06-11 02:22:23 
Re: ANSI syntax for outer join
Fernando Nunes <domuso  2008-06-11 11:07:19 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:48:36 CST 2008.