mysql使用EXISTS代替join

SELECT a.id FROM a WHERE a.id = 5100359  AND EXISTS ( SELECT b.id FROM b WHERE a.id = b.id) ORDER BY a.id DESC LIMIT 0, 5

posted @ 2018-03-22 15:53  jintaonote  阅读(417)  评论(0编辑  收藏  举报