SELECT 1 FROM HOSTACCMAST HTAM WHERE VC.VOUCHERTYPENO='A01'
AND VC.VOUCHERNO=HTAM.ACCOUNTNO
SELECT * from score;
select 1 from SCORE t where t.stuid ='B010';
-
delete from score s where s.courseid = '化学';
delete from score s where s.courseid = '科学';
SELECT * from score;
select 1 from SCORE t where t.stuid ='B010';
select 1 from SCORE t where t.stuid ='xxx';