→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎05-30-2016 08:23 AM
Solved! Go to Solution.
‎05-30-2016 06:34 PM
Select Top 1000000 htblticketstates.statename As [State Name],
Count(htblticketstates.statename) As Amount
From htblticket
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Group By htblticketstates.statename
Having htblticketstates.statename In ('Closed', 'Open', 'Pending')
‎05-30-2016 06:34 PM
Select Top 1000000 htblticketstates.statename As [State Name],
Count(htblticketstates.statename) As Amount
From htblticket
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Group By htblticketstates.statename
Having htblticketstates.statename In ('Closed', 'Open', 'Pending')
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now