rugzo Posted May 11, 2009 Share Posted May 11, 2009 Hi All, i have a qustion about using 2 tables -> table a email ticketvolume ------- --------- o@i.com 10 f@i.com 13 g@i.com 12 table b users email team -------- ------- o@i.com team a f@i.com team b r@i.com team a g@i.com 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... Quote 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' Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/157677-solved-multiple-table-query/#findComment-831843 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.