多表不同结构表连接

洛溪zzZ

select "实际销售" as 类型,"宠物用品" as 产品类别 ,"南京" as 所属区域, * from [D:\data\数据1\南京.xls].[宠物用品$] union all
select "实际销售" as 类型,"警告标志" as 产品类别 ,"南京" as 所属区域 ,* from [D:\data\数据1\南京.xls].[警告标志$] union all
select "实际销售" as 类型,"户外睡袋" as 产品类别 ,"南京" as 所属区域 ,* from [D:\data\数据1\南京.xls].[户外睡袋$] union all
select "实际销售" as 类型,"宠物用品" as 产品类别 ,"苏州" as 所属区域 ,* from [D:\data\数据1\苏州.xls].[宠物用品$] union all
select "实际销售" as 类型,"警告标志" as 产品类别 ,"苏州" as 所属区域 ,* from [D:\data\数据1\苏州.xls].[警告标志$] union all
select "实际销售" as 类型,"户外睡袋" as 产品类别 ,"苏州" as 所属区域 ,* from [D:\data\数据1\苏州.xls].[户外睡袋$] uniom all

select "销售计划" as 类型,产品类别,所属区域,null,null,销售部门,null,null,null,null,金额,null from [D:\data\数据1\销售计划.xlsx].[销售计划$]
两个表都能单独做出来 但是连接就是有问题 死活找不到，真的求求大佬们解答， 崩溃了快

q1579398897

1. select "实际销售" as 类型,"宠物用品" as 产品类别 ,"南京" as 所属区域,销售部门,金额 from [C:\Users\Administrator\Desktop\数据1\南京.xls].[宠物用品$] union all
   
2. select "实际销售" as 类型,"警告标志" as 产品类别 ,"南京" as 所属区域,销售部门,金额 from [C:\Users\Administrator\Desktop\数据1\南京.xls].[警告标志$] union all
   
3. select "实际销售" as 类型,"户外睡袋" as 产品类别 ,"南京" as 所属区域,销售部门,金额 from [C:\Users\Administrator\Desktop\数据1\南京.xls].[户外睡袋$] union all
   
4. select "实际销售" as 类型,"宠物用品" as 产品类别 ,"苏州" as 所属区域,销售部门,金额 from [C:\Users\Administrator\Desktop\数据1\苏州.xls].[宠物用品$] union all
   
5. select "实际销售" as 类型,"警告标志" as 产品类别 ,"苏州" as 所属区域,销售部门,金额 from [C:\Users\Administrator\Desktop\数据1\苏州.xls].[警告标志$] union all
   
6. select "实际销售" as 类型,"户外睡袋" as 产品类别 ,"苏州" as 所属区域,销售部门,金额 from [C:\Users\Administrator\Desktop\数据1\苏州.xls].[户外睡袋$] union all
   
7. select "销售计划" as 类型,产品类别,所属区域,销售部门,金额 from [C:\Users\Administrator\Desktop\数据1\销售计划.xlsx].[销售计划$]

复制代码

洛溪zzZ

q1579398897 发表于 2019-9-24 17:55

谢谢谢谢 我自己也找到原因了

洛溪zzZ

q1579398897 发表于 2019-9-24 17:55

非常感谢 我自己也找到原因了，，错了一个字母