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??? :)

• Next in forum: Deadlocks, why?
• Prev in forum: Full-text search across multiple tables
• Thread view: Baffled! Can't figure out how to do this query. Is it even possible?

[Reply to this message]