none
Query Strategy for this please?

    Question

  • There are two tables, AccountsOpen and AccountsClosed, which keeps track of which employee has openedand closedeach account

    AccountsOpen

      EmployeeID (int)

      AccountID (int)

     

    AccountsClosed

      EmployeeID (int)

      AccountD (int)

    If an employee closes an account they get 1 point

    If no one closes an account, the employee that opens the account gets 1 point

      


    Monday, November 19, 2012 11:57 PM

Answers