SELECT BM, NR, 编码, 内容 FROM ZQ select id, sum(case when [区别]='以上' then [以上] else null end), sum(case when [区别]='以下' then [以下] else null end) from a group by id 这两张表怎么在不建立视图的情况下,通过虚拟表的方式建立,ZQ的编码与a的ID进行左连接
SELECT BM, NR, 编码, 内容,b.* FROM ZQ a left join (select id, sum(case when [区别]='以上' then [以上] else null end) [col1], sum(case when [区别]='以下' then [以下] else null end) [col2] from a group by id ) b on a.编码=b.id
select zq.columns,tb.columns from zq left join (select id, sum(case when [区别]='以上' then [以上] else null end), sum(case when [区别]='以下' then [以下] else null end) from a group by id ) tb on zq.编码=tb.id--这样、?
SELECT * FROM ZQ LEFT JOIN ( select id, sum(case when [区别]='以上' then [以上] else null end), sum(case when [区别]='以下' then [以下] else null end) from a group by id)A ON ZQ.编码 = A.id
1、with cteas( select * from ZQ left join a on ZQ.编码=a.id ) select * from cte2、select * into #x from ZQ left join a on ZQ.编码=a.id
select * into #t from (SELECT BM, NR, 编码, 内容,b.* FROM ZQ a left join (select id, sum(case when [区别]='以上' then [以上] else null end) [col1], sum(case when [区别]='以下' then [以下] else null end) [col2] from a group by id ) b on a.编码=b.id )t
select * from (SELECT BM, NR, 编码, 内容 FROM ZQ) ta left join (select id, sum(case when [区别]='以上' then [以上] else null end), sum(case when [区别]='以下' then [以下] else null end) from a group by id) tb on a.编码=b.id
left join (select
id,
sum(case when [区别]='以上' then [以上] else null end) [col1],
sum(case when [区别]='以下' then [以下] else null end) [col2]
from a group by id
) b
on a.编码=b.id
(select
id,
sum(case when [区别]='以上' then [以上] else null end),
sum(case when [区别]='以下' then [以下] else null end)
from a group by id
) tb on zq.编码=tb.id--这样、?
FROM ZQ
LEFT JOIN ( select
id,
sum(case when [区别]='以上' then [以上] else null end),
sum(case when [区别]='以下' then [以下] else null end)
from a group by id)A ON ZQ.编码 = A.id
select * from ZQ left join a on ZQ.编码=a.id
)
select * from cte2、select * into #x from ZQ left join a on ZQ.编码=a.id
*
into
#t
from
(SELECT BM, NR, 编码, 内容,b.* FROM ZQ a
left join (select
id,
sum(case when [区别]='以上' then [以上] else null end) [col1],
sum(case when [区别]='以下' then [以下] else null end) [col2]
from a group by id
) b
on a.编码=b.id
)t
(SELECT BM, NR, 编码, 内容 FROM ZQ) ta
left join
(select
id,
sum(case when [区别]='以上' then [以上] else null end),
sum(case when [区别]='以下' then [以下] else null end)
from a group by id) tb
on a.编码=b.id
无法绑定由多个部分组成的标识符 "dbo.a.id"
无法绑定由多个部分组成的标识符 "dbo.ZQ.编码"报这个错误呢