-
SELECT A.FIRMNBR
FROM TA_ALARM_D A, TA_RATE_D B
WHERE B.PRODUCTID = A.PRODUCTID
AND B.TRANSTYPE = A.TRANSTYPE
AND B.RATE || ( SELECT OPERATOR FROM TA_ALARM_D C
WHERE C.PRODUCTID = A.PRODUCTID
AND C.TRANSTYPE = A.TRANSTYPE ) || A.RATE
Hi,
In the above query, in the last condition of 'where clause', I want to pass some relational operators
(like '=','<','>' etc.) dynamically from a table column and then parse the main query to get the result records
from the outer main query.
How could i achieve this.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|