Hi
Select distinct T0.code,T0.Name from Item T0 where T0.ItemCode = (Select distinct(Itemcode) from Item2)
Thanks