nested select problem
From: Brandon <brandon.g.jones_at_gmail.com>
Date: Fri, 11 Jul 2008 06:20:36 -0700 (PDT)
Message-ID: <af978045-2d60-4229-ae50-c15c271c6dd6@i76g2000hsf.googlegroups.com>
Date: Fri, 11 Jul 2008 06:20:36 -0700 (PDT)
Message-ID: <af978045-2d60-4229-ae50-c15c271c6dd6@i76g2000hsf.googlegroups.com>
I have a statement that executes in SQL*Plus but not within Pro*C.
I'm guessing it has to do with where the nested select is (I know it
works from the where clause)
SELECT foo, (SELECT bar from baz where id = 1) FROM table1 WHERE ....
Pro*C does not like the "SELECT bar". Can I not place nested selects in this part of my statement when compiling with Pro*C? Received on Fri Jul 11 2008 - 08:20:36 CDT