请问这样的sql语句怎么统计记录条数呢
jsp
请问这样的sql语句怎么统计记录条数呢
select   pro_products.*   ,pro_company.*   from   pro_products,pro_company   where   pro_products.iCompanyId=pro_company.iId

------解决方案--------------------
select count(*) from pro_products,pro_company where pro_products.iCompanyId=pro_company.iId
------解决方案--------------------
楼上正解~~~~
------解决方案--------------------
select count(*) from pro_products,pro_company
同时两个表，行么？