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

Right. So, I can ever use IN (SELECT group by patient) or INNER JOIN (select ... )