Access SQL JOINS

[cleteh]

Whenever I try to join a 2nd table in a SQL query in Access I get a syntax error (missing operator) in query expression

Here is the code:

SELECT A.FileNo, A.Amount, A.Payee, A.Debtor, A.Creditor, B.TotInt
FROM CheckPayments A
INNER JOIN TotalInterest B On A.FileNo = B.FileNo
INNER JOIN File_No C On A.FileNo = C.FileNo;

[jonh]

use the query builder and copy the sql.

[cleteh]

Whenever I try the query wizard I get an error saying one of these tables isn't related to the others. It says to fix in relationships, so i open that which ive never had to do before. The field im trying to join on is fileno. I don't understand what's happening.

[cleteh]

That worked