数据操纵的SQL语句及其执行结果说明.doc

数据操纵的SQL语句及其执行结果说明:
1.
SELECT ,,,/* ,*/,DoctorName,Symptoms,History,AllergicHistory,InitialDiagnosis,NurseNo
FROM Patient, InPatientAdmi ,MedicalAdvice, MedicalRecords
WHERE = and = AND = /*AND =*/
AND =( SELECT PatientNo
FROM WardDistribution
WHERE BedNo='3'
and WardNo='WN011102');
/*执行结果说明:
PatientName
PatientGender
PatientAge
PFNo
DrName
Symptoms
InitialDiagonsis
冯帆
男
20
PFN011005003
李丹
恶心头痛腹泻食欲不振。腹部疼痛
胃病
*/
2.
SELECT ,,,,,TreatName,
FROM MedicalAdvice,MedicalExam,DetailsOfTreat
WHERE = and =
AND IN (SELECT MANo
FROM MedicalAdvice
WHERE PatientName='罗玉凤'
AND /*datediff(day,MadeTime,getdate())<=7*/ MadeTime BETWEEN '2010-04-23 00:00:00'
AND '2010-05-01 00:00:00');
/*执行结果说明:
MANo
DrName
MadeTime
NurseNo
TestResult
TreatName
TreatPeriod
MAN0110042611
王亚琼
2010/4/26
NN0101
炎症
特殊药物治疗
10/04/27至10/05/4
MAN0110042814
王亚琼
2010/4/28
NN0104
血压偏高