Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Join Syntax in Access

Posted on 2010-08-26
3
Medium Priority
?
229 Views
Last Modified: 2012-05-10
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);
0
Comment
Question by:avalonwgi
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 33532727
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
 

Author Comment

by:avalonwgi
ID: 33533795
Hi Angellll, I tried that and still the same error.
0
 

Author Closing Comment

by:avalonwgi
ID: 33533831
I got it...there was an extra bracket set not needed.  Thanks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question