rathgar Posted September 21, 2007 Share Posted September 21, 2007 Hey Guys, New guy here. Glad to be here :-). I've been having a problem with what seems to be a simple sql query. There are two tables I'm comparing to find out how many times people from a group (in this sample millennium) have entered a entry into the job_id field. (Job ID could be say.. Marketing, or IT, or whatever) The code below returns all the people in the group and all the entries, and even lists them in order, but all I need is a count per person of the entries, and not a list of them all. I'm sure it's really simple. Just got me stumped. SELECT * FROM `tbl_times` as A,`tbl_group_members` as B WHERE B.p_id = A.p_id AND B.g_id = "millennium" ORDER BY A.p_id,job_id DESC What I need is: Name, Job_Id, Entries Joe Blogs, Accounting, 5 Joe Blogs, Marketing, 2 Sam French, Accounting, 5 Sam French, Marketing, 12 And so forth. Thanks in advance guys, Cheers, Quote Link to comment https://forums.phpfreaks.com/topic/70092-count-sum-stumped/ Share on other sites More sharing options...
rathgar Posted September 21, 2007 Author Share Posted September 21, 2007 Nevermind, I'm a retard. Just worked it out. So simple. Cheers anyway, Rath Quote Link to comment https://forums.phpfreaks.com/topic/70092-count-sum-stumped/#findComment-352071 Share on other sites More sharing options...
fenway Posted September 21, 2007 Share Posted September 21, 2007 Nevermind, I'm a retard. Just worked it out. So simple. Cheers anyway, Rath How? Quote Link to comment https://forums.phpfreaks.com/topic/70092-count-sum-stumped/#findComment-352394 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.