I have a sql query i am trying to get the count of how rows it returned.
select a.field1, b.field2, c.field2 from table1 as a, table2 as b, table2 as c where a.field1=b.field1
Considered the above query return 9 rows. I want to get count of '9' in a mysql query. Please help. Thanks in advance.