What is Scalar Subquery?

Answer: A scalar subquery is an ordinary SELECT query in parentheses that returns exactly one row with one column.

Example:

SELECT fieldname, (SELECT max(fieldname) FROM tableB WHERE tableB.fieldname = tableA.fieldname)
    FROM tableA;