Good job! It's your turn to write a query with non primary-foreign key equality.
We want to know if there are any patients and physicians who have the same email in our clinic. Perhaps physicians also attend our clinic or former patients were hired by the clinic?
List the first and last name of each patient (name the columns PatientFirstName and PatientLastName) and the first and last name of each physician (name the columns PhysicianFirstName and PhysicianLastName) for patients and physicians who share the same email address.
Type:
SELECT Patient.FirstName AS PatientFirstName, Patient.LastName AS PatientLastName, Physician.FirstName AS PhysicianFirstName, Physician.LastName AS PhysicianLastName FROM Patient JOIN Physician ON Patient.Email = Physician.Email
