>We finally had a chance to work with my colleague. We do want only patients with the 2 visits on the same date. So, the original inner select was correct.
>
>Here is the query that works:
>

>select V.patient_name, V.visit_date, V.doctor_name, DOCTORS.doctor_specialty
>
>from Visits V INNER JOIN DOCTORS ON V.doctor_name=DOCTORS.doctor_name
>
>WHERE EXISTS(SELECT patient_name, visit_date FROM Visits
>
>                    WHERE patient_name=V.patient_name
>
>                      AND visit_date=V.visit_date
>
>group by patient_name, visit_date
>
>having count(VISITS.visit_date)>1
>
>)
>
>

However it is horrible