Inner join problem - 3 tables

[aliashippysmom]

I haven't used Access in quite a while and am trying to join 3 tables. I'm getting syntax errors. I have tried doing the query with no table aliases, adding parens where I think they need to go. MS says to do all the INNER JOIN clauses first, still no go. Here is the query:

SELECT * FROM Groups 
INNER JOIN (Member_Group  ON Member_Group.groupID = groups.ID)
INNER JOIN (Members  ON members.ID = member_Group.membershipID) 
WHERE m.ID = 1948

I am getting (now) a syntax error in the JOIN clause.

Does anyone have any ideas? I've stared at this for the past hour or so

Thanks in advance!

 

[SkipVought]

hi,

Are you coding this or using the interactive query grid in MS Access query?

If the former, then why not the latter?

If the latter, then I can't see why you would get an error.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[aliashippysmom]

Thanks for your reply. I am coding this myself and not using the query grid (not sure what that is). I inherited a bunch of ASP code and am making some changes. Would the query grid help identify the error?

 

[SkipVought]

Not unless you're in MS Access...
[tt]
SELECT *

FROM
Groups
, Member_Group
, Members

Where Member_Group.groupID = groups.ID
AND members.ID = member_Group.membershipID
AND [red]m[/red].ID = 1948
[/tt]
maybe...
[tt]
SELECT *

FROM
Groups
, Member_Group
, Members

Where Member_Group.groupID = groups.ID
AND members.ID = member_Group.membershipID
AND groups.ID = 1948
[/tt]
????



Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[aliashippysmom]

Thanks. I've downloaded the database and am able to use MS Access 7 to open and display the data. I've tried to use the Query building options, but that's not really what I need. I just need someway to run this query as I have it written using their interface. Is this a pass-thru query? I just need a screen where I can copy and paste what I have.

Thanks again.

 

[PHV]

What about this ?

SELECT * FROM (Groups G 
INNER JOIN Member_Group MG ON G.groupID = MG.ID)
INNER JOIN Members M ON MG.membershipID = M.ID
WHERE M.ID = 1948

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aliashippysmom]

Yea, that's better. But now I get "invalid use of null". Is that because it doesn't find a record in one of the join tables?

 

[PHV]

I get "invalid use of null"
What is YOUR whole actual SQL code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886