What does the following query return?
select
mt1.AcctNo,
mt1.Mdate,
count(*) as RecCnt
from
dbo.MyTable01 mt1
inner join dbo.MyTable2 mt2
on (m1.AcctNo = mt2.AcctNo
and m1.Mdate = mt2.Mdate)
group by
mt1.AcctNo,
mt1.Mdate
having
count(*) > 1
order by
mt1.AcctNo,
mt1.Mdate;