Is it possible to perform an innerJoin to know the quantity of the second table?

Question

I am making a database with two entities, where entity "A" is a category, and in each category contains several items, in the case entity "B", what I need to know is: it is possible to bring information from entity A with the amount of items in table B?

SELECT tabelaA.*, tabelaB.count(*) FROM tabelaA INNER JOIN tabelaB 
WHERE tabelaA.id = tabelaB.id
GROUP BY tabelaA.id;

Answer 1

I do not understand very well but I think this is it. use alias for table name is cleaner.

SELECT A.*, COUNT(B.categoria) as ContarCategoria FROM tabelaA A INNER JOIN tabela B  ON A.id = B.id GROUP BY A.id;