途观之旅记录片:select 语句嵌套查询语句

来源:百度文库 编辑:高考问答 时间:2024/04/29 08:42:26
从表userinfo(此表也含有userid)中选出与表result的userid不同的所有数据~!请大家帮帮忙~!

select * from userinfo where userinfo.userid not in(select result.userid from result)

select * from userinfo where userid not in(
select userid form result)