串联查询 [英] Concatenating Queries

问题描述

我需要将两个查询合并在一起，但是它们的结构不完全相同.

查询之一的结构是:名称，部门，总销售费用

查询二的结构是:名称，部门，总计
数据查询一个.

fred dvd's 250
戴夫唱片300
唐表音乐150


数据查询二

fred dvd's 100
戴夫记录350
丹尼斯DVD 200

结果查询

fred dvd的250100
戴夫记录300350
唐表音乐150 0
丹妮丝DVD 0 200

谢谢

Scott

I need to join two queries together but they don''t have exactly the same structure..

the structure of query one is : name, department, totalsalesafrica

the sturcture of query two is : name, department, totalsaleseurope

Data query one..

fred dvd''s 250
dave records 300
don sheetmusic 150


Data query two

fred dvd''s 100
dave records 350
denise dvd''s 200

Resultant query

fred dvd''s 250 100
dave records 300 350
don sheetmusic 150 0
denise dvd''s 0 200

Thanks

Scott

推荐答案

您可以尝试

You could try

<br />
select name,department,totalsalesafrica as Salesafrica, 0 as SalesEurope from table1<br />
UNION<br />
select name,department,0 as Salesafrica, totalsaleseurope as SalesEurope from table2

您可以使用内部选择.我不知道如何设置您的表，但这将是这样的:

You could use inner selects. I dont'' know how your tables are setup but it would be something like this:

SELECT NAME, DEPT, 
(SELECT SUM(SALES) FROM TblSales WHERE TblSales.REGION=''AFRICA'' AND TblSales.NAME=TblCustomers.NAME AND TblSales.DEPT=TblCustomers.DEPT) AS AfricaSales, 
(SELECT SUM(SALES) FROM TblSales WHERE TblSales.REGION=''EUROPE'' AND TblSales.NAME=TblCustomers.NAME AND TblSales.DEPT=TblCustomers.DEPT) AS EuropeSales 
FROM TblCustomers

这篇关于串联查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！