摘要: SELECT c.userId, c.userName FROM (SELECT * FROM a UNION SELECT * FROM b) c WHERE c.userId NOT IN (SELECT b.`userId` FROM a JOIN b ON a... 阅读全文
posted @ 2016-06-15 10:26 lhm_java 阅读(331) 评论(0) 推荐(0) 编辑
摘要: 1 SELECT 2 c.userId, 3 c.userName 4 FROM 5 (SELECT 6 * 7 FROM 8 a 9 UNION 10 SELECT 11 * 12 FROM 13 b) c 14 WHERE c.userId NOT IN 15 (SELECT 16 b.`use 阅读全文
posted @ 2016-06-15 10:23 lhm_java 阅读(273) 评论(0) 推荐(0) 编辑