Create a DSN to connect to the Northwind database on a SQL Server.
Link the following tables from the Northwind database: Customers, Orders, and Order Details.
Create the following query, and then save it as qryLevel1:
SELECT dbo_Customers.CompanyName, dbo_Orders.OrderID
FROM dbo_Customers INNER JOIN dbo_Orders ON dbo_Customers.CustomerID = dbo_Orders.CustomerID;
Create the following query and then save it as qryFinal:
SELECT [dbo_Order Details].ProductID, qryLevel1.OrderID
FROM [dbo_Order Details] LEFT JOIN qryLevel1 ON [dbo_Order Details].OrderID = qryLevel1.OrderID;
Run the qryFinal query. Note that you receive the error message that is mentioned in the "Symptoms" section of this article. When you run this same query on a computer that has the latest edition of the Jet Service Pack installed, the query runs as expected.
Visit :
http://www.seosew.com