• Is there a typo in your question? It looks like you want the following to be returned, unless I have misunderstood:

    ID Stat StatDate

    1 AppRec 2012-12-01

    1 AppCom 2012-12-02

    If so, this will do it:

    SELECT ID, Stat, StatDate

    FROM Apps

    WHERE ID IN (SELECT ID FROM Apps WHERE Stat = 'AppRec' AND StatDate >= '2012-12-01')