Error in Access query: Cannot repeat table name in FROM clause

Question

I am receiving an error when trying to perform a query - "Cannot repeat table name 'Jobs' in FROM clause." Below is how the query is written.

SELECT Jobs.[Contract Amt], Jobs.[Job Name], Jobs.Location, Jobs.[Comp Date], Customers.[Cust Name], Customers.Contact, Customers.Phone

FROM Jobs, (JOBS INNER JOIN Customers ON Jobs.[Cust Name] = Customers.[Cust Name]) INNER JOIN [PRE-QUAL] ON Customers.[Cust Name] = [PRE-QUAL].[Cust Name]

WHERE (((Jobs.Rept)="1"));

Answer 1

Try

SELECT Jobs.[Contract Amt], Jobs.[Job Name], Jobs.Location, Jobs.[Comp Date], Customers.[Cust Name], Customers.Contact, Customers.Phone

FROM (Jobs INNER JOIN Customers ON Jobs.[Cust Name] = Customers.[Cust Name]) INNER JOIN [PRE-QUAL] ON Customers.[Cust Name] = [PRE-QUAL].[Cust Name]

WHERE (((Jobs.Rept)="1"));