A main query can have mroe than one subquery.

A subquery can have more than one main query.

The sub query and main query must retrieve data from the same table.

The subquery and main query can retrieve data from different tables.

Only one column or expression can be compared between the subquery and main query.