Home Forums SQL Server 2008 T-SQL (SS2K8) if 2nd year and same Programme for same Student, then return no results RE: if 2nd year and same Programme for same Student, then return no results

  • January 11, 2012 at 12:36 pm

    #1432058

    Hi Paul, thanks for your quick response. Must admit, your method is much simpler. (wish I had your SQL knowledge).

    The query is used as a filter - to remove all students who already registered the year before and now registered again for the same Programme. I apply the filter to another query.