The Tables
1
UserID, UserName
2
UserID, Type
(all of the above are int except UserName)
(Type Ranges from 1-2)
result
UserName, count(Type==1), count(Type==2)
ex.
1 looks like
1 — testUser
2 looks like
1 — 1
1 — 1
1 — 2
1 — 2
1 — 1
result should look like
testUser — 3 — 2