query question--repost

[middletree]

I posted this around Midnight, didn't get a reply, so am posting it again in
case the ones with an answer might be awake and see it.
-----------------------------------------------
Using classic ASP, and Access 2000, I got an error. The details of my
original problem were posted late Sunday night; look for post with
"complicated
query--join" as subject line.

Following the advice given to me there (which makes lots of sense to me), I
try to run this SQL statement:

select P.PersonalID,P.FName,P.LName,P.PreferredName,PG.GiftID,PA.AreaID,
PAB.AbilityID, PP.PeopleID
FROM Personal P
INNER JOIN PersonalGift PG ON P.PersonalID = PG.PersonalID
INNER JOIN PersonalArea PA ON P.PersonalID = PA.PersonalID
INNER JOIN PersonalAbility PAB ON P.PersonalID = PAB.PersonalID
INNER JOIN PersonalPeople PP ON P.PersonalID = PP.PersonalID
WHERE PG.GiftID LIKE *
AND PA.AreaID LIKE *
AND PAB.AbilityID LIKE *
AND PP.PeopleID LIKE *

but I get this error:

Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'P.PersonalID =
PG.PersonalID
INNER JOIN PersonalArea PA ON P.PersonalID = PA.PersonalID
INNER JOIN PersonalAbility PAB ON P.PersonalID = PAB.PersonalID
INNER JOIN PersonalPeople PP ON P.PersonalID = PP.PersonalID'.

I can't figure out what this error is telling me. Any help would be
appreciated.

 

[Brendan Reynolds \(MVP\)]

I think it's complaining about missing parentheses. Try creating the query
using the Access query designer, which will take care of putting in the
parentheses for you, then switch to SQL view and copy and paste the SQL
statement. (You'll need to tidy it up a little, because the pasted SQL
statement will include line breaks.)

 

[middletree]

Gosh, I hope it's that simple. Will try it out.

thanks