Select from mysql, and count from other row

Question

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?

I think you should do 2 queries, one to count the results and one to get them. It would result in code easier to maintain. — adrian7

Nitesh morajkar Nitesh morajkar · Accepted Answer · 2013-09-22T11:50:29

0

votes

You can use INNER JOIN on that id.

Select from mysql, and count from other row

1 Answers