Select count of rows in another table in a Postgres SELECT statement February 6, 2023 by Tarik SELECT A.*, (SELECT COUNT(*) FROM B WHERE B.a_id = A.id) AS TOT FROM A