有2个表A,B
表A
uid gender (1男,2女)
1 1
2 2
3 1
4 2
5 1
表B
uid department (1客服部,2运营部)
1 1
2 1
3 2
4 2
5 1
怎么样写 SELECT COUNT(*),可以
统计 客服部,男性的 数量
谢谢
SELECT COUNT(*) from A, B where A.uid=B.uid and A.gender =1 and B.department=1
谢谢版主