How can I do a few count without a loop ?? Thanks in advance;)

  • four
    Clarify the question. And the feeling that we are on the program "Guess the melody" - Deonis
  • Most likely a question about grouping. @diamond, read here: dev.mysql.com/doc/refman/5.1/en/… - _rMX_

1 answer 1

The first row is related to the third, this is getting the quantity from the first table, and the second row is getting the quantity from the second table.

SELECT COUNT(*), (SELECT COUNT(*) FROM `second`) FROM `first`