query in a query sql code example
Example 1: NESTED QUERY SQL
SELECT column_name [, column_name ]
FROM table1 [, table2 ]
WHERE column_name OPERATOR
(SELECT column_name [, column_name ]
FROM table1 [, table2 ]
[WHERE])
Example 2: in query in sql
SELECT Id, FirstName, LastName, Country FROM Customer WHERE Country IN (SELECT Country FROM Supplier)