|
我在access里面做的一个query可以正常运行,但是在excel里面怎么都找不到。请问是什么原因,谢谢先了。
这是我的select语句:
SELECT Q2_group_by_forecast.months as Month,Q2_group_by_forecast.ph3 as PH3,Q2_group_by_forecast.[ship to code] as [ship to code],0 as[volume budget],0 as [NS budget],0 as [CM budget],Q2_group_by_forecast.[volume forecast] as [volume forecast],Q2_group_by_forecast.[NS forecast] as [NS forecast],Q2_group_by_forecast.[CM forecast] as [CM forecast] from Q2_group_by_forecast
UNION
select Q2_months_budget.months as Month,Q2_months_budget.ph3 as PH3,Q2_months_budget.[ship to code] as [ship to code],Q2_months_budget.[volume budget] as [volume budget],Q2_months_budget.[NS budget] as [NS budget],Q2_months_budget.[CM budget] as [CM budget],0 as [volume forecast],0 as [NS forecast],0 as [CM forecast] from Q2_months_budget;
|
|