macromedia.coldfusion.database_access
[Top] [All Lists]

Another Set of Eyes Please

Subject: Another Set of Eyes Please
From: Steve Miller <s.miller@xxxxxxxxxxxx>
Date: Wed, 16 Jan 2008 13:19:43 -0600
Newsgroups: macromedia.coldfusion.database_access


Hello - I've looked through this a hundred times and can not figure out what the issue is. Can I borrow another set of eyes to tell me what I am missing?

SELECT Members.member_ID, Members.member_FirstName, Members.member_LastName, Results.results_MemID, Sum(Results.results_Points) AS Total_Pts
FROM Members INNER JOIN Results ON Members.member_ID = Results.results_MemID
GROUP BY Members.member_ID

This version works:
SELECT results_MemID, Sum(results_Points) AS Total_Pts
FROM Results
GROUP BY results_MemID

But I need to get the Member ID, First and Last Names from the Members table.

Thank you in advance for any help,
Steve

<Prev in Thread] Current Thread [Next in Thread>