Hi
i have query below, but it is giveing me error 'subquery return more then one row',
how to resolve ,because i want to check column value in subquery..
please provide alternate solution of this.
SELECT * FROM RAPIN_PENDING RP
WHERE RECIPIENT_PMN = decode('ALL','ALL',
( select distinct(ROAMING_OPERATOR)
from BILATERAL_AGREEMENT
where client_operator in (select tadig from userlogin_tadig WHERE username= lower('baysquare'))
)
,'ALL');