>>SELECT VISITS.patient_name, VISITS.visit_date >>FROM VISITS GROUP BY VISITS.patient_name, VISITS.visit_date >>HAVING count(VISITS.visit_date)>1; >>>>
>SELECT VISITS.patient_name, VISITS.visit_date > FROM VISITS > GROUP BY VISITS.patient_name, VISITS.visit_date > HAVING (((count(VISITS.visit_date))>1)); >>
>SELECT Doctors.*, Visits.* > FROM Doctors > INNER JOIN > (SubQ INNER JOIN Visits ON > (SubQ.Visit_Date = Visits.Visit_Date) AND (SubQ.Patient_Name = Visits.Patient_Name)) > ON Doctors.Doctor_Name = Visits.Doctor_Name; >>
>SELECT Doctors.*, Visits.* > FROM Doctors > INNER JOIN > ( SELECT VISITS.patient_name, VISITS.visit_date > FROM VISITS > GROUP BY VISITS.patient_name, VISITS.visit_date > HAVING (((count(VISITS.visit_date))>1)) ) as SubQ > INNER JOIN Visits ON > (SubQ.Visit_Date = Visits.Visit_Date) AND (SubQ.Patient_Name = Visits.Patient_Name)) > ON Doctors.Doctor_Name = Visits.Doctor_Name; >>Cetin
SELECT Doctors.*, Visits.* FROM Doctors INNER JOIN (SELECT VISITS.patient_name, VISITS.visit_date FROM VISITS GROUP BY VISITS.patient_name, VISITS.visit_date HAVING count(VISITS.visit_date)>1 ) as SubQ INNER JOIN Visits ON (SubQ.Visit_Date = Visits.Visit_Date) AND (SubQ.Patient_Name = Visits.Patient_Name)) ON Doctors.Doctor_Name = Visits.Doctor_Name;