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