Reply to Baffled! Can't figure out how to do this query. Is it even possible?
Posted by jonescv on 01/13/06 20:53
I have an "Issues" table for my technicians. An issue can be on "hold"
or "assigned".
I want to get a count for each tech with a column showing number of
issues on hold and a column for number of issues assigned. It would
look like this --
Tech Num_Assigned Num_On_Hold
Fred 3 10
Carol 6 7
I can get each column separately, but I want both in the same answer
table!
Is that too much to ask??? :)