<div>
Hi Angellll, I tried that and still the same error.
</div>


Hi Angellll, I tried that and still the same error.

<div>
I got it...there was an extra bracket set not needed. &nbsp;Thanks.
</div>


I got it...there was an extra bracket set not needed.  Thanks.

<div>
<div class="content wysiwyg-content">
I am getting a join syntax error and I have no idea why<br />
<br />
SELECT dbo_ApSupplier.Supplier, dbo_ApSupplier.SupplierNam<wbr />e, dbo_ApInvoice.Invoice, dbo_ApInvoice.InvoiceDate,<wbr /> dbo_ApInvoice.DueDate, dbo_ApInvoice.OrigInvValue<wbr />, SubQryPymt.TtlPymt, [dbo_ApInvoice]![OrigInvVa<wbr />lue]+[SubQ<wbr />ryPymt]![T<wbr />tlPymt] AS EndingBal<br />
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);
</div>
</div>


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);

SQL Join Syntax in Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.