SQL查询帮助

我认为会更好

SELECt COUNT(*) FROM TABLE1 WHERe NOT EXISTS (SELECt Table1Id FROM TABLE2 WHERe TABLE2.Table1Id = TABLE1.Table1Id AND UserID = 1)

我也将检查索引，如ck建议