SQL Join Syntax in Access

I am getting a join syntax error and I have no idea why

SELECT dbo_ApSupplier.Supplier, dbo_ApSupplier.SupplierName, dbo_ApInvoice.Invoice, dbo_ApInvoice.InvoiceDate, dbo_ApInvoice.DueDate, dbo_ApInvoice.OrigInvValue, SubQryPymt.TtlPymt, [dbo_ApInvoice]![OrigInvValue]+[SubQryPymt]![TtlPymt] AS EndingBal
FROM (dbo_ApSupplier INNER JOIN ([SubQryPymt] INNER JOIN dbo_ApInvoice ON [SubQryPymt].Invoice = dbo_ApInvoice.Invoice) ON (dbo_ApSupplier.Supplier = [SubQryPymt].Supplier) AND (dbo_ApSupplier.Supplier = dbo_ApInvoice.Supplier);
avalonwgiAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
you might want to add more brackets
SELECT dbo_ApSupplier.Supplier, dbo_ApSupplier.SupplierName, dbo_ApInvoice.Invoice, dbo_ApInvoice.InvoiceDate, dbo_ApInvoice.DueDate, dbo_ApInvoice.OrigInvValue, SubQryPymt.TtlPymt, [dbo_ApInvoice]![OrigInvValue]+[SubQryPymt]![TtlPymt] AS EndingBal
FROM dbo_ApSupplier INNER JOIN ([SubQryPymt] INNER JOIN dbo_ApInvoice ON ([SubQryPymt].Invoice = dbo_ApInvoice.Invoice) ) ON (dbo_ApSupplier.Supplier = ([SubQryPymt].Supplier) AND (dbo_ApSupplier.Supplier = dbo_ApInvoice.Supplier);

Open in new window

0
 
avalonwgiAuthor Commented:
Hi Angellll, I tried that and still the same error.
0
 
avalonwgiAuthor Commented:
I got it...there was an extra bracket set not needed.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.