I forgot:
This is Oracle 816
"sylvain tremblay" <syltrem_at_videotron.ca> a écrit dans le message de news:
t0Qq8.42841$Be7.2073405_at_weber.videotron.net...
> Hi
>
> From the doc, subqueries are valid inside the FROM and WHERE clause
> but can someone tell me if this is valid? I get an error at compile time.
> If it`s not valid, then how should I do this kind of query in PL/SQL ?
>
> Thanks
> Syltrem
>
> Cursor Open_Order_Cur
> is Select ORDER_NUMBER, SALES_ORDER_TYPE,
> CUSTOMER_REFERENCE, ORDER_DATE, USERNAME,
> WEIGHT, VOLUME, SOP_ORDER_TOTAL_CURRENCY,
> STATUS_FLAG,
> (Select Count(*)
> From FINANCE.SALES_ORDER_LINES L
> Where L.COMPANY_CODE = H.COMPANY_CODE
> And L.DIVISION = H.DIVISION
> And L.ORDER_NUMBER = H.ORDER_NUMBER)
> From FINANCE.SALES_ORDER_HEADERS H
> Where H.COMPANY_CODE = P_Company
> And H.DIVISION = P_Division
> And H.CUSTOMER_NUMBER = P_Customer_Id
> And H.STATUS_FLAG <> 'C';
>
>
>
Received on Wed Apr 03 2002 - 21:49:38 CST
