3.3w+
社区成员
- 全部
- 基础类
- 应用实例
- 新技术前沿
联合查询问题
select tusers_t.* from tusers,tusers_t where tusers_t.scardid=tusers.scardid;
以上语句可以实现查询表tusers_t和表tusers字段scardid相同的数据；
请问如何查询表tusers_t有，而表tusers没有的scardid？
以上语句可以实现查询表tusers_t和表tusers字段scardid相同的数据；
请问如何查询表tusers_t有，而表tusers没有的scardid？
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
kadeya 2005-08-06
select scardid
from tusers_t
where scardid not in (select scardid from tusers)
from tusers_t
where scardid not in (select scardid from tusers)
QQMagicer 2005-08-06
select *
from tusers_t
where tusers_t.scardid not in(select tusers.scardid from tusers)
from tusers_t
where tusers_t.scardid not in(select tusers.scardid from tusers)
tangqijun199 2005-08-06
select tusers_t.* from tusers_t b left join tusers a on b.scardid=a.scardid;
where a.主键 is null
where a.主键 is null
fhuibo 2005-08-06
select tusers_t.* from tusers,tusers_t where tusers_t.scardid<>tusers.scardid
lovewindy 2005-08-06
select tusers_t.* from tusers_t where scardid not in (select scardid from tusers)
好像这样也可以吧,
好像这样也可以吧,
xiaonvjing 2005-08-06
请问如何查询表tusers_t有，而表tusers没有的scardid？
select a.scardid,b.scardid from tusers_t a left join tusers b on a.scardid=b.scardid where b.scardid is null
