时间: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)