Multiple Inner Joins

[czupet]

I am using Access database and jdbc

I have no problem when I am using 2 or less inner joins, but when I add a third Inner join I get 

Error:java.sql.SQLException:General error

Is there anything I can do to fix this problem?

Thank You

Peter.

Here's my query:

SELECT

     `Table1`.`MembershipID`,

     `Table1`.`Mailing Name`,

     `Table1`.`InformalSalutation`,

     `Table1`.`Tag_name`,

     `Table1`.`LastName`,

     `Table1`.`FamGroupID`,

     `Table1`.`Status`,

     `Table1`.`Address_3`,

     `Table1`.`Address_1`,

     `Table1`.`Address_2`,

     `Zip`.`State`,

     `Zip`.`City`,

     `Zip`.`Zip`,

     `Table2`.`Date`,

     `Table2`.`Amount`,

     `Table2`.`CheckNo`,

     `Table3`.`COA ID`,

     `Table3`.`Description`,

     `Table2`.`PledgeID`,

     `Table1`.`SendNoMail`

FROM

     `Table1` `Table1` INNER JOIN `Zip` `Zip` ON `Table1`.`ZipID` = `Zip`.`ID`

     INNER JOIN `Table2` `Table2` ON `Table1`.`DioUniqueID` = `Table2`.`Family_DUID`

     INNER JOIN `Chart of Accounts` `Table3` ON `Table2`.`AccountID` = `Table3`.`COA ID`

WHERE

     `Table1`.`Status` = TRUE

 AND `Table1`.`FamGroupID` = 2

 AND `Table1`.`SendNoMail` = FALSE