sqlserver in 子查询问题
- WBOYOriginal
- 2016-06-07 15:25:231102browse
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)
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：DB父子 vs. OO父子（技术）Next article：Navicat 无法远程连接到 MySQL