select * from SUPPLY_ORDERS
where
exists (
select 1 from SUPPLY_VENDORS
where
substring(sv_name,1,9) = 'CAR STOCK'
--sv_name like 'CAR STOCK%'
and so_svid = sv_id
)
and substring(so_pono,1,3) = 'STA'
--and so_pono like 'STA%'
order by so_insertdate desc;