>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.

Yes, your original query was pointing to that. Then just remove the date component from subselect.
Cetin