Hello,
How can I substitute "exists" in the following query:
select *
from tables
where adj.REASON_CD not in ('LG01','LGLF')
and adj.ADJUSTMENT_ID in (select max(a.adjustment_id)
from web1.adjustment a
where a.master_account_id = da.MASTER_ACCOUNT_ID)
Thanks in advance,
BV