Return to Answer

added 567 characters in body

Source Link

edited Jun 26, 2012 at 19:24

i tried subquery and inner join of subqueriehave 2 tables in my access 2010DB, customer and contracts and they are related through the customerid,

this is the script i use normally

SELECT Customer.CustomerName 
FROM Customer INNER JOIN Contracts ON Customer.CustID = Contracts.CustomerID;

and it does workworks fine and this is how its represented in the design view

try Normal Table

i changed my query to

SELECT Customer.CustomerName
FROM Customer INNER JOIN (select * from Contracts) derivedtable ON Customer.CustID = derivedtable.CustomerID;

similar to yours and it your self, checkgave me same results and this link as wellis how its represented in the design view

design view derived table

i hope it clarifies

i tried subquery and inner join of subquerie in access 2010 and it does work

try it your self, check this link as well

i have 2 tables in my access DB, customer and contracts and they are related through the customerid,

this is the script i use normally

SELECT Customer.CustomerName 
FROM Customer INNER JOIN Contracts ON Customer.CustID = Contracts.CustomerID;

and it works fine and this is how its represented in the design view

Normal Table