ジ绯色月下ぎ

摘要： select * from AAA where id in (select id from BBB)等价于：select * from AAA where exists(select * from BBB where BBB.id=AAA.id) 执行顺序不同，in 先执行内层查询，exists先查 阅读全文