• How many rows are returned with the following query?

    select

    mt1.*

    from

    DBO.MyTable01 mt1

    where

    mt1.Type IN (10,810)

    and exists (select 1 from dbo.MyTable2 mt2 where mt1.AcctNo = mt2.AcctNo and mt1.Mdate = mt2.Mdate)

    Edit: Modified code slightly.