Thread: query dependent on another query

Want to make query dependent on another query.

In MS-Access 2003 I have created ten fields, on that fields I have to create query. I would like to create query on these fields in such a way that one reliant on the other. It means when one query run its reliant query is automatically run. Can anybody help me to how to make query dependent on another query.

It is very easy to create query reliant on another query. You have to just insert one query's name into another. In this manner you have to insert one query's name into another to get the result. Try to understand following code which I given below.

SELECT tableName.[Companys], tableName.[Companys] FROM tableName where not(tableName.[Companys]) is null UNION SELECT "*", "<All>" From tableName

ORDER BY 2;

Try to understand following code which is helps you to make query dependent on another query.


USE AdventureWorks ;
GO
SELECT DISTINCT c.LastName, c.FirstName
FROM Person.Contact c JOIN HumanResources.Employee e
ON e.ContactID = c.ContactID WHERE EmployeeID IN
(SELECT SalesPersonID
FROM Sales.SalesOrderHeader
WHERE SalesOrderID IN
(SELECT SalesOrderID
FROM Sales.SalesOrderDetail
WHERE ProductID IN
(SELECT ProductID
FROM Production.Product p
WHERE ProductNumber LIKE'FW%')));
GO