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