请问这样的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
同时两个表，行么？