Select from mysql, and count from other row

I have 2 tables.

Table1: id, row1, row2, row3, etc.

Table2: id, row1, row2, etc.

I need to do a query, that select id, row1, row2 from Table1. But i also want it, to count how many rows, that exists. With the id given from table1, compared to the id in table2.

How can i do that?

---

您可以在该ID上使用INNER JOIN。

链接地址: http://www.djcxy.com/p/75332.html

上一篇: 如何编写mysql查询以准确返回4行

下一篇: 从mysql中选择，并从其他行中计数