请教这样的sql语句如何统计记录条数呢
请问这样的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
同时两个表，行么？
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
同时两个表，行么？