query error

[middletree]

Using classic ASP, and Access 2000, I got an error. The details of my
original problem as from 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.