We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
MySQL
SELECT *, (SELECT COUNT(tableb.tableA_id) FROM TableB WHERE TableB.tableA_id = tablea.id) AS count FROM TableA tablea;
I have a Parent table and child table with foreign key association. i need to query parent table along with count of each id in child table.