Çó½ÌÒ»ÌõsqlÓï¾ä - MS-SQL Server / »ù´¡Àà

SQL code:

create table student (sid varchar(10),sname varchar(10),sage varchar(10),ssex varchar(10))
create table Sc (sid varchar(10),cid varchar(10),score int)
insert into sc select '0001','001',80
insert into sc select '0001','001',90
insert into sc select '0001','002',70
insert into sc select '0001','003',85
insert into sc select '0002','001',50
insert into sc select '0003','001',60
insert into sc select '0003','002',70
insert into sc select '0004','001',60
insert into sc select '0004','002',70
insert into sc select '0004','003',80
insert into sc select '0004','004',90
insert into student select '0001','swichin','26','ÄÐ'
insert into student select '0002','lamh','27','ÄÐ'
insert into student select '0003','ballack','34','ÄÐ'
insert into student select '0004','lucio','32','ÄÐ'


²éѯÓëijѧÉúѧµÄÒ»Ñù»òÕ߸ü¶àµÄ¿Î³ÌµÄѧÉú
±ÈÈçѧÉú0001ѧϰÁË 001£¬002£¬003¿Î³Ì
ÄÇô·ûºÏÌõ¼þµÄѧÉúÖ»ÓÐ0004ÕâÒ»¸öÁË

---

select sname from student where ¿Î³ÌID£¨²»ÖªµÀÄĸö´ú±í¿Î³Ì£©= 001or¿Î³ÌID=002or¿Î³ÌID=003 Ó¦¸ÃÊÇÕâÑù£¬ºÇºÇ ²»Ì«È·¶¨ ÄãÊÔһϰÉ~~~

---

¶ÔÁË ÄǸösc±í²»·ûºÏ·¶Ê½£¬ ¼ÓÒ»¸öѧÆÚÁаÉ

ÕâÑù sid£¬class£¬Ñ§ÆÚ Èý¸öÁÐ×÷ΪÁªºÏÖ÷¼ü

---

SQL code:
--> Éú³É²âÊÔÊý¾Ý±í: [tb]
IF OBJECT_ID('[student]') IS NOT