select
distinct
ltrim(a.t_item) as ParentItem,
ltrim(a.t_dsca) as ParentDescription,
(select ltrim(t_revi) from edm
where t_indt = (select max(t_indt) from edm where ltrim(t_eitm) = ltrim(a.t_item))--@item)
and ltrim(t_eitm) = ltrim(a.t_item)) as ParentRevision,
max(t_indt) as ParentEffectiveDate
from
itm a
join
edm b
on ltrim(a.t_item) = ltrim(b.t_eitm)
where
ltrim(t_item) = in (select * from Split(@ItemList,',')) --@item
group by a.t_item, a.t_dsca