select b.isdept from realschedule.scskutbl a,invdb.invmst b where a.scheduleno in () and a.webshow='Y' and a.skuno=b.skuno and b.idept='100' group by b.isdept order by b.isdept