dynamic column name
From: NOVA <nova1427_at_gmail.com>
Date: Sun, 25 May 2008 04:33:19 -0700 (PDT)
Message-ID: <41c114f7-8676-453d-a9ac-4326d6b59964@t54g2000hsg.googlegroups.com>
The output from inner query is 'SRC' and it is single row. The outer table 'PRODUCTS_T' has SRC column.
Date: Sun, 25 May 2008 04:33:19 -0700 (PDT)
Message-ID: <41c114f7-8676-453d-a9ac-4326d6b59964@t54g2000hsg.googlegroups.com>
Dear all,
I have problem, the query as the following:
- SELECT
- CASE
- WHEN PRODUCT_TYPE IN (SELECT PRODUCT_TYPE FROM PROD_T WHERE TYPE_COL='ACCEPT_OS')
- THEN (SELECT RESULT FROM PROD_T WHERE PRODUCT_TYPE=OUTER.PRODUCT_TYPE)
- ELSE 0
- END ACCEPT_OS
- FROM PRODUCTS_T OUTER
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; Received on Sun May 25 2008 - 06:33:19 CDT