How do I add subquery into the main query?

S

SokkiHong

How do I add subquery into the main query? Do I just
start typing the next query after the ";"? I am new to
SQL, any help will be appreciated.
 
A

Allen Browne

In query design view, you can type your subquery into the Field row if you
want it to return a column. This makes it part of the SELECT clause.

If you do not need to see a column, the subquery can go other places, such
as in the WHERE clause.
 
Top