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.