34,588
社区成员
发帖
与我相关
我的任务
分享
select 企业编码,企业名称,COUNT(*)
from (
select *,1 as rn from A
union all
select *,2 as rn from B
) as t1
group by 企业编码,企业名称
[/quote]
好像不行吧?我加上count(*) 报错了select 企业编码,企业名称,COUNT(*)
from (
select *,1 as rn from A
union all
select *,2 as rn from B
) as t1
group by 企业编码,企业名称
if OBJECT_ID('A') IS NOT NULL
DROP TABLE [A]
CREATE TABLE [A](企业编码 varchar(10),企业名称 varchar(30),领购日期 varchar(20),领购数量 int)
insert into [a]
select '001' ,'上海一线公司','2013-12-25',50 union all
select '001','上海一线公司','2013-12-28',120
if OBJECT_ID('B') is not null
drop table[B]
create table [B] (企业编码 varchar(10),企业名称 varchar(30),出库日期 varchar(20),数量 int)
insert into [B]
select '001' ,'上海一线公司','2013-12-24',30 union all
select '001','上海一线公司','2013-12-26 ',190
select * from A
SELECT * FROM B
--select * from [a] innser join [B] on 1=1
select A.企业编码,A.企业名称, A.领购日期 as 领票日期,A.领购数量 as 本次购票数量 from A
UNION ALL
select b.企业编码,b.企业名称, b.出库日期 as 领票日期,b.数量 as 本次购票数量 from B
select 企业编码,企业名称,领购日期,领购数量
from (
select *,1 as rn from A
union all
select *,2 as rn from B
) as t1
order by 企业编码,rn desc,领票日期
[/quote]
谢谢您了,非常感谢。能给我解释下吗?select 企业编码,企业名称,领购日期,领购数量
from (
select *,1 as rn from A
union all
select *,2 as rn from B
) as t1
order by 企业编码,rn desc,领票日期
select *
from (
select *,1 as rn from A
union all
select *,2 as rn from B
) as t1
order by 企业编码,rn desc,领票日期