Category : C Source Code
Archive   : SQLVER1.ZIP
Filename : SELECT.CMD

SELECT*FROM HOSPITAL;
SELECT*FROM WARD;
SELECT*FROM LAB;
SELECT*FROM PATIENT;
SELECT*FROM DOCTOR;
SELECT*FROM HLAB;
SELECT*FROM STAFF;
SELECT SNAME,
SDUTY,
WNAME FROM
WARD,STAFF WHERE
STAFF.WCODE=WARD.WCODE AND
STAFF.HCODE=WARD.HCODE;


SELECT SNAME,
SDUTY,
WNAME,
HNAME FROM
WARD,
STAFF,
HOSPITAL WHERE
STAFF.WCODE =WARD.WCODE AND
STAFF.HCODE =WARD.HCODE AND
STAFF.HCODE =HOSPITAL.HCODE AND
HOSPITAL.HCODE=WARD.HCODE;
SELECT SNAME,
SDUTY,
WNAME,
HNAME FROM
WARD,
STAFF,
HOSPITAL WHERE
STAFF.WCODE =WARD.WCODE AND
STAFF.HCODE =WARD.HCODE AND
STAFF.HCODE =HOSPITAL.HCODE AND
HOSPITAL.HCODE=WARD.HCODE AND
'Psychiatric' =WNAME;

SELECT LNAME,
LADDRESS,
HNAME,
HADDRESS FROM
LAB,
HOSPITAL,
HLAB WHERE
HLAB.HCODE=HOSPITAL.HCODE AND
HLAB.LABNO=LAB.LABNO;

SELECT HNAME,
WNAME,
HOSPITAL.HADDRESS FROM
WARD,
HOSPITAL WHERE
WARD.HCODE=HOSPITAL.HCODE;

SELECT DOCNAME,
DOCSPLTY,
HOSPITAL.HNAME,
HOSPITAL.HADDRESS FROM
DOCTOR,
HOSPITAL WHERE
HOSPITAL.HCODE=DOCTOR.HCODE;

SELECT HNAME,
LNAME FROM
LAB,
HLAB,
HOSPITAL WHERE
HOSPITAL.HCODE = HLAB.HCODE AND
LAB.LABNO = HLAB.LABNO AND
HLAB.HCODE > HLAB.LABNO;

SELECT SNAME,
SEMPNO,
SDUTY,
SSHIFT,
WNAME,
HNAME FROM STAFF,
WARD,
HOSPITAL WHERE
HOSPITAL.HCODE=STAFF.HCODE AND
HOSPITAL.HCODE=WARD.HCODE AND
STAFF.HCODE =WARD.HCODE AND
WARD.WCODE =STAFF.WCODE AND
SSHIFT<'E';
SELECT SNAME,
SEMPNO,
SDUTY,
SSHIFT,
WNAME,
HNAME FROM STAFF,
WARD,
HOSPITAL WHERE
HOSPITAL.HCODE=STAFF.HCODE AND
HOSPITAL.HCODE=WARD.HCODE AND
STAFF.HCODE =WARD.HCODE AND
WARD.WCODE =STAFF.WCODE AND
SSHIFT='E';

SELECT SNAME,
SEMPNO,
SDUTY,
SSHIFT,
WNAME,
HNAME FROM STAFF,
WARD,
HOSPITAL WHERE
HOSPITAL.HCODE=STAFF.HCODE AND
HOSPITAL.HCODE=WARD.HCODE AND
STAFF.HCODE =WARD.HCODE AND
WARD.WCODE =STAFF.WCODE AND
SSHIFT>'E';

SELECT SNAME,
SEMPNO,
SDUTY,
SSHIFT,
WNAME,
HNAME FROM STAFF,
WARD,
HOSPITAL WHERE
HOSPITAL.HCODE=STAFF.HCODE AND
HOSPITAL.HCODE=WARD.HCODE AND
STAFF.HCODE =WARD.HCODE AND
WARD.WCODE =STAFF.WCODE AND
SSHIFT>'E' AND
HNAME='Doctors';

SELECT SNAME,
SEMPNO,
SDUTY,
SSHIFT,
WNAME,
HNAME FROM STAFF,
WARD,
HOSPITAL WHERE
HOSPITAL.HCODE=STAFF.HCODE AND
HOSPITAL.HCODE=WARD.HCODE AND
STAFF.HCODE =WARD.HCODE AND
WARD.WCODE =STAFF.WCODE AND
SSHIFT>'E' AND
HNAME='Doctors' AND
WNAME='Psychiatric';






EXIT;