Thanks to this great community I've already had a huge success in my data searching. Using:

```
select patient.last, patient.first, patient.birth, count(*)
from patient
group by patient.last, patient.first, patient.birth
having count(*) > 1

```

It listed out all my duplicate values! Now, I'd like to take this a step farther so that I can list ONLY those duplicates that have an appointment on a certain day. There are several issues I'm running into though. 

First only one of the two duplicates will have an appointment.  

Second the appointment date is stored on a different table (fun enough called APPT)

I tried:

```
select appt.date
from appt
where appt.date=curdate()+1
union
select patient.last, patient.first, patient.birth, count(*)
from patient
group by patient.last, patient.first, patient.birth
having count(*) > 1

```

But this caused an error about columns not matching. I couldn't figure out how to innerjoin because when I selected appt.date it affected the group by.

Any thoughts?