Re: dynamic column name
Date: Sun, 25 May 2008 18:15:35 GMT
NOVA <nova1427_at_gmail.com> wrote in news:41c114f7-8676-453d-a9ac- 4326d6b59964_at_t54g2000hsg.googlegroups.com:
> Dear all,
> I have problem, the query as the following:
> 1: SELECT
> 2: CASE
> 3: WHEN PRODUCT_TYPE IN (SELECT PRODUCT_TYPE FROM PROD_T WHERE
> 4: THEN (SELECT RESULT FROM PROD_T WHERE
> 5: ELSE 0
> 6: END ACCEPT_OS
> 7: FROM PRODUCTS_T OUTER
> The problem in Line #5
> The output from inner query is 'SRC' and it is single row.
> The outer table 'PRODUCTS_T' has SRC column.
> I want specify the column name from inner query (line #5).
> It is like dynamic column name.
> How can solve it?
> Best Regards;
-- but is scales about as well as a pig can fly. Received on Sun May 25 2008 - 13:15:35 CDT