How do I add subquery into the main query?

[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.

 

[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.