Menu
select a.ptid,a.name from producttype a inner join productgroup b on a.pgid=b.pgid where b.pgid=2 order by a.sno