SQL Statement to help with this one...

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

Answer 1

Can you post the query? What is the question?

---

Kalman Toth SQL 2008 GRAND SLAM
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012