Your query will work in 8i (at least I'm sure about 8.1.6, not so certain about 8.1.5), but not in 8.0. BTW, subquery can now be anywhere in the select clause, not only in WHERE - it can also be in FROM clause or in select list, as in your case.
|
Results 1 to 3 of 3
Thread: Subquery syntax problem
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote