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
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