SQL Join - Syntax error (missing operator) when using two Joins in query

[PavelSimek]

Please help... In Invoices table record in my "Excel database" i keep supplier ID and customer ID when I list all invoices for a certain period i need names instead of IDs. With one INNER JOIN (for only one "BusinessPartner") the query works, as soon as I use two it reports an error.

SELECT
Invoices.ID,
Supplier.BusinessPartnerName AS SupplierName,
Customer.BusinessPartnerName AS CustomerName,
Invoices.VS,
Invoices.Total
FROM
[Invoices$] as Invoices
INNER JOIN
[BusinessPartners$] AS Supplier ON Invoices.SuppID = Supplier.ID;
INNER JOIN
[BusinessPartners$] AS Customer ON Invoices.CustID = Customer.ID
WHERE
Invoices.DueDateUS >= #06/24/2024# AND Invoices.DueDateUS <= #07/24/2024# AND (Invoices.AlreadyPayed = 'FALSE' OR Invoices.NotPayed = 'FALSE') ORDER BY Invoices.DueDateUS DESC

Thank you in advance,
Pavel

 

[JEC]

Remove the semi colon after the first INNER JOIN line

PS: I would use Power Query to merge tables in Excel

 

[PavelSimek]

Remove the semi colon after the first INNER JOIN line

PS: I would use Power Query to merge tables in Excel

Thank you very much for the answer, the semicolon is not the problem (I didn't have it in the original query), the problem is the syntax of two consecutive JOIN statements. When I use one JOIN, the query runs fine, as soon as I add the second one (to same table, just on a different record), Excel reports a syntax error (missing operator). I will try Power Query, thanks for the tip.