MySQL显示未连接的结果
MySQL显示未连接的结果
提问于 2018-08-01 04:13:42
我用下面的查询连接两个表：
select * from t1
LEFT JOIN t2 ON t1.First1=t2.FirstName
and t1.Last1=t2.LastName
and t1.City=t2.City
and t1.ST=t2.State;现在，我如何运行一个单独的查询来打印t2中未连接的行？
我尝试对字段使用NOT IN，但收到错误: Error Code: 1241。操作数应包含1列
select * from t2 where t2.RefID NOT IN (
select * from t1,t2 where t1.First1=t2.FirstName
and t1.Last1=t2.LastName
and t1.City=t2.City
and t1.ST=t2.State);回答 1
Stack Overflow用户
发布于 2018-08-01 04:29:08
翻转联接并检查是否有不匹配的...
select * from t2
LEFT JOIN t1 ON t1.First1=t2.FirstName
and t1.Last1=t2.LastName
and t1.City=t2.City
and t1.ST=t2.State
WHERE t1.someid IS NULL
;页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/51621349
复制相关文章
相似问题