我认为会更好
SELECt COUNT(*) FROM TABLE1 WHERe NOT EXISTS (SELECt Table1Id FROM TABLE2 WHERe TABLE2.Table1Id = TABLE1.Table1Id AND UserID = 1)
我也将检查索引，如ck建议
我认为会更好
SELECt COUNT(*) FROM TABLE1 WHERe NOT EXISTS (SELECt Table1Id FROM TABLE2 WHERe TABLE2.Table1Id = TABLE1.Table1Id AND UserID = 1)
我也将检查索引，如ck建议
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
