参考地址 :https://www.cnblogs.com/liyasong/p/sql_in_exists.html
直接上结论:查询B表时结果集大适合使用select * from A where exist (select * from B where A.ID = B.ID)
查询A表时结果集大适合使用select * from A where A.ID IN (select * from B where A.ID = B.ID)
参考地址 :https://www.cnblogs.com/liyasong/p/sql_in_exists.html
直接上结论:查询B表时结果集大适合使用select * from A where exist (select * from B where A.ID = B.ID)
查询A表时结果集大适合使用select * from A where A.ID IN (select * from B where A.ID = B.ID)