SQL Combining Results

SELECT

(SELECT COUNT(*) FROM tablea) AS counta,

(SELECT COUNT(*) FROM tableb) AS countb;

Bibliography