求SQL:MsSQL 转 Oracle 的
山尖美色 2005-09-20 06:59:14 下面是MsSQL的sql语句:
update CUTOTAL CUTOTAL set TEACH_NO = select CUDATATMP.TEACH_NO from CUDATATMP CUDATATMP where CUTOTAL.COURSE_NO=CUDATATMP.COURSE_NO and CUTOTAL.CLASS_NO=CUDATATMP.CLASS_NO and CUTOTAL.SEM_NO='666' and CUDATATMP.SEM_NO='666'
oralce sql:
???