rugzo Posted May 11, 2009 Share Posted May 11, 2009 Hi All, i have a qustion about using 2 tables -> table a email ticketvolume ------- --------- [email protected] 10 [email protected] 13 [email protected] 12 table b users email team -------- ------- [email protected] team a [email protected] team b [email protected] team a [email protected] teama ------ here i have to count the ticket volum of team a. Is that possible to count the volume of team a in one sql query. It has to check how many tickets is handled by x person and then add the volume to the specific team to which he belongs to. thanks... Link to comment https://forums.phpfreaks.com/topic/157677-solved-multiple-table-query/ Share on other sites More sharing options...
luca200 Posted May 11, 2009 Share Posted May 11, 2009 select sum(ticketvolume) from b join a on b.email = a.email where b.team = 'team a' Link to comment https://forums.phpfreaks.com/topic/157677-solved-multiple-table-query/#findComment-831494 Share on other sites More sharing options...
rugzo Posted May 11, 2009 Author Share Posted May 11, 2009 Thank you very much Link to comment https://forums.phpfreaks.com/topic/157677-solved-multiple-table-query/#findComment-831843 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.