Hi,
I have a script as below
IF Exists(
select a.tgl2,a.Dosen,a.nmdos,a.MK,a.nmk,a.drn,a.dosen,b.mk,b.prioritas from view_jadwalkuliah a
left join view_kurdosen b on a.mk=b.mk and a.dosen=b.dosen where a.drn >1
)
Begin
select a.tgl2,a.Dosen,a.nmdos,a.MK,a.nmk,a.drn,a.drn+1 as ndrn,b.dosen,b.nmdos,b.mk,b.prioritas from view_jadwalkuliah a
left join view_kurdosen b on a.mk=b.mk and a.drn+1=b.prioritas where a.drn >1
END
I need to put it into a view..but there's an error said " Incorrect syntax near IF " can anyone help me for the solution?
thx