SO i think this query is going to be complex and i just cant work it out
i have
[tblpack]
-packid
-packuser
checkuser
collectuser
[tbluser]
userid
username
So i want this:
Name Count Packed Count checked count Collect John 5 4 1 Paul 7 55 5 Ringo 1 1 2
i literally dont have a clue how to get here!!
harder than this i have [packdate] in the tblpack that i want to use as awhere clause.
Now tbl user is connected to each other count queries, so i want to count how many times each user has appeared in the field of tblpack
SQL for ONE is easy..
SELECT tbluser.userfirstname, Count(tblpack.packid) AS CountOfpackid
FROM tbluser INNER JOIN tblpack ON tbluser.userid = tblpack.packeduser
GROUP BY tbluser.userfirstname;
But i really need a hand getting the larger one
Any help would be amazing.
This will eventually be put into a matrix plot on RDLC in C# on visual studio..
Gangel