rathgar

Nevermind, I'm a retard. Just worked it out. So simple. Cheers anyway, Rath

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,