Yii Framework Forum: Database Help - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Database Help Rate Topic: -----

#1 User is offline   Cliff 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 11
  • Joined: 27-January 12
  • Location:Ontario, CANADA

Posted 29 December 2012 - 11:26 PM

Hello All,
I am working on a web application for a client which is a reporting system.

They have a system they want to run reports on the system has a table

tickets with columns ticketid and departmentid

and a table

ticketposts with columns ticketid(foreign key) and staffid

I want to be able to count how many total tickets there are grouped by department id as well as count how many ticketposts there were for a specific departmentid(the department id is not in the ticketposts table) if the column staffid is greater than 0(is a staff member)

Thanks
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users