SQL question(在线等，谢谢！！） - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

SQL question(在线等，谢谢！！）

SQL question(在线等，谢谢！！）# Database - 数据库

B*a2003-11-20 08:11

1 楼

Tables and keys:
patient (patientID, lastName, firstName, bMonth, bDay, bYear,
accountID) key: patientID
account (accountID, balance, responsibleParty) key: accountID
visit (patientID, vMonth, vDay, vYear, description, charge,
doctorID) key: patientID, vMonth, vDay, vYear
doctor (doctorID, drName, degreeYear) key: doctorID
diagnosis (dCode, dDescription) key: dCode
visitDiagnosis (patientID, vMonth, vDay, vYear, dCode) key:
patientID, vMonth, vDay, vYear, dCode
Query: Which patient(s) have been

c*t2003-11-20 08:11

2 楼

Too complex, it's better to write a SP.

【在 B****a 的大作中提到】

: Tables and keys:
: patient (patientID, lastName, firstName, bMonth, bDay, bYear,
: accountID) key: patientID
: account (accountID, balance, responsibleParty) key: accountID
: visit (patientID, vMonth, vDay, vYear, description, charge,
: doctorID) key: patientID, vMonth, vDay, vYear
: doctor (doctorID, drName, degreeYear) key: doctorID
: diagnosis (dCode, dDescription) key: dCode
: visitDiagnosis (patientID, vMonth, vDay, vYear, dCode) key:
: patientID, vMonth, vDay, vYear, dCode

n*a2003-11-20 08:11

3 楼

select patient.patientID, patient.lastName, patient.firstName
from visitDiagnosis, patient, diagnosis
where visitDiagnosis.patientID=patient.patientID
and visitDiagnosis.dCode=diagnosis.dCode
group by patient.patientID, patient.lastName, patient.firstName,
visitDiagnosis.dDescription, visitDiagnosis.vMonth,
visitDiagnosis.vYear
having count(*) = 2
order by patient.firstName;

【在 B****a 的大作中提到】