SQL Builder limitation

[tanvirtonu1]

One of my SQL is working well in MSAccess but the same SQL is not working in ireport sql builder.
I m using odbc connection for MSAccess DB.One more thing that I saw is there is no SQL for multiple
tables;I mean SQL like- tableA.col1=tableB.col1 AND tableC.col1=tableD.col1 and so on.Can anybody tell me
what the problem is with my SQL, the error says- too few parameters but it is running well in
MSAccess query design.And is there anyway I can have multiple table SQL option as mentioned above.

 

Code:

SELECT DISTINCT     SalesInvoice.`ID` AS SalesInvoice_ID,     Unit.`ID` AS Unit_ID,     Unit.`UniteSize` AS Unit_UniteSize,     Unit.`LocationID` AS Unit_LocationID,     Customer.`ID` AS Customer_ID,     Customer.`Name` AS Customer_Name,     SalesInvoice.`TotalAmount` AS SalesInvoice_TotalAmount,     SalesInvoice.`Commission` AS SalesInvoice_Commission,     SalesInvoice.`Paid` AS SalesInvoice_Paid,     SalesInvoice.`Due` AS SalesInvoice_DueFROM     `SalesInvoice` SalesInvoice,     `Unit` Unit,     `Customer` CustomerWHERE     SalesInvoice.ID = UniteSalse.SalesInvoiceID AND UniteSalse.ID = Unit.ID AND SalesInvoice.CustomerID = Customer.ID AND SalesInvoice.ID = '1'