Question

8. List the names of doctors who have no patients. [Use NOT IN query]

IlIness Diagnosis Illness Code Illness Desc Department Pres No Patient N0 Medication Code Dosage Physician JD Last Name Patient-No ness Code Tel Extensian Specialty Assignment Paticnt Medication FnysicianJD Patient No Role patient No Last Name First Name Age Gentder Medicatian Cade On Hand On Order Unit Cost

Answer 1

We want to find out a doctor who has no patients. This means In the Assignment Table there will be not be any entry for the doctor, but the doctor will have entry in the Physician table.

Query is:

Select Physician_ID

from Physician

where Physician_ID

NOT IN

(Select Physician_ID from Assignment);

This Query will take Physician_ID from the Physician table and subtract the Physicians from the Assignment Table.