insert into @a values(1, '1')
insert into @a values(2, '2')
insert into @a values(1, '2')
select * from @a where (a = 1 and b = '1') and (a = 2 and b = '2')
查询结果为什么是空?
...全文
11914打赏收藏
一个复杂的SQL语句请教
declare @a table (a int, b varchar(10)) insert into @a values(1, '1') insert into @a values(2, '2') insert into @a values(1, '2') select * from @a where (a = 1 and b = '1') and (a = 2 and b = '2') 查询结果为什么是空?