为什么要用子查询?select count(1) from t_paymentMark A,
T_payable as B,
T_invIN as C
where a.paymentID = 1
and ( ( A.billtype = '1' and A.payableID = B.payableID )
or (A.billtype = '0' and A.payableID = c.invInID) )
T_payable as B,
T_invIN as C
where a.paymentID = 1
and ( ( A.billtype = '1' and A.payableID = B.payableID )
or (A.billtype = '0' and A.payableID = c.invInID) )
就是派生表的 join 而已