| 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_MemIDBut 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> |
|---|---|---|
| ||
| Previous by Date: | Re: Problem with SQL Security Settings, Ian Skinner |
|---|---|
| Next by Date: | Re: Problem with SQL Security Settings, Mike Palmquist |
| Previous by Thread: | Problem with SQL Security Settings, Mike Palmquist |
| Next by Thread: | Re: Another Set of Eyes Please, Ian Skinner |
| Indexes: | [Date] [Thread] [Top] [All Lists] |