how to pass 2 queries in oledbcommand at a time?

A SQL nested query is a SELECT query that is nested inside a SELECT, UPDATE, INSERT, or DELETE SQL query. Here is a simple example of SQL nested query:

product table contains columns Model, ManufacturerID ,Manufacturer 
////

SELECT Model FROM Product
WHERE ManufacturerID IN (SELECT ManufacturerID FROM Manufacturer
WHERE Manufacturer = 'Dell')

The nested query above will select all models from the Product table manufactured by Dell:


//output
Model
Inspiron B120
Inspiron B130
Inspiron E1705