>I think I set up the condition wrongly. We want all patients that have more than 1 visit in total with all visits information. Right now we're getting patients that have more than 1 visits on the same day.
SELECT VISITS.patient_name, VISITS.visit_date
FROM VISITS
WHERE VISITS.patient_name IN (SELECT patient_name FROM VISITS GROUP BY patient_name HAVING COUNT(*) >1)
Now I start looking your file
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.