当前位置:Gxlcms > mysql > sqlserverin子查询问题

sqlserverin子查询问题

时间:2021-07-01 10:21:17 帮助过:3人阅读

create table db_user(id int primary key,name nvarchar(256)); go insert into db_user select 1,'test_1' union all select 2,'test_2' union all select 3,'test_3' ; go create table db_score(score_id int, user_id varchar(256),score varchar(256))

create table db_user(id int primary key,name nvarchar(256));
go

insert into db_user select 1,'test_1' union all
select 2,'test_2' union all
select 3,'test_3' ;
go

create table db_score(score_id int, user_id varchar(256),score varchar(256));
go
insert into db_score select 1, '1,2','90' union all
select 2,'3','80'
go

查询报错:

select id,name from db_user where id in(select user_id from db_score where score_id =1)

人气教程排行