select * from Info I where I.ID in (select p.Id from table1 p)
select * from Info I where I.ID in (select p.Id from table1 p group by p.Id)