Error with INSERT INTO query

[mdavid]

Hi,
I have the following SQL query:

INSERT INTO ComplaintsWithSystemDisorder (ComplaintID, MempSpeciesID, BercSpeciesID, Complaint)
SELECT ComplaintID, SpeciesID, Tab2.SpeciesID, Complaint
FROM MempBercWithComplaints Tab1
INNER JOIN BercComplains Tab2 ON Tab2.SpeciesID = Tab1.BercID

And I'm getting error:

Access can't represent the JOIN expression Tab2.SpeciesID = Tab1.BercID in Design View.

As far as I can see the above fields exist.

Not sure if I need to use LEFT or RIGHT JOIN. I want to include all records from MempBercWithComplaints Tab1 and some records from BercComplaints Tab2



Thanks for any help

[June7]

Are you using the query designer? Build SELECT statement with query designer to get the join correct. Why bother with the table aliases?

Should BercComplains have a 't' in there?

[mdavid]

Thanks June, Yep that was it, missing a 't' - strange how you see things that aren't there.

And thanks for the suggestion to use query designer - always thought this stuff would be to complicated for a dummy designer, so was trying to help out by writing the SQL - who's the dummy!?