SELECT count(rz_refer.refer_id) as refer,count(rz_client.client_id) as fault
FROM rz_refer,rz_client从两张表里面查询各自的记录总数,我这样查有什么问题?
我查出的结果总是refer和fault的值相等,应该怎么该?
FROM rz_refer,rz_client从两张表里面查询各自的记录总数,我这样查有什么问题?
我查出的结果总是refer和fault的值相等,应该怎么该?
FROM rz_client
FROM rz_refer
FROM rz_refer a inner join
rz_client b on a.id=b.id