select kdggs,kddsn,nmdsn from master_dosen
where kddsn not in
(select KdDsn
from TrRumpunIlmuDosen
where stsrc=’A’ and priod=’2011′ and kdsem=’1′)
and stsrc=’A’
order by kdggs
Load daftar dosen tidak punya rumpun ilmu
Leave a Comment
select kdggs,kddsn,nmdsn from master_dosen
where kddsn not in
(select KdDsn
from TrRumpunIlmuDosen
where stsrc=’A’ and priod=’2011′ and kdsem=’1′)
and stsrc=’A’
order by kdggs