以下是那裡錯誤.請指點一下
select [期初明細$].廠別,[期初明細$].倉別,[期初明細$].品名,[期初明細$].物料編碼,[期初明細$].單位,[期初明細$].數量 as 期初數量,[期初明細$].金額 as 期初金額,0 as 預估入庫數量,0 as 預估入庫金額,0 as 入庫數量,0 as 入庫金額,0 as 預估出庫數量,0 as 預估出庫金額,0 as 出庫數量,0 as 出庫金額,0 as 補料數量,0 as 補料金額,0 as 差異數量,0 as 差異金額 from [期初明細$] union all select [預估入庫$].廠別,[預估入庫$].倉別,[預估入庫$].品名,[預估入庫$].物料編碼,[預估入庫$].單位,0 as 期初數量,0 as 期初金額,[預估入庫$].數量 as 預估入庫數量,[預估入庫$].金額 as 預估入庫金額,0 as 入庫數量,0 as 入庫金額,0 as 預估出庫數量,0 as 預估出庫金額,0 as 出庫數量,0 as 出庫金額,0 as 補料數量,0 as 補料金額,0 as 差異數量,0 as 差異金額 from [預估入庫$] union all select [入庫明細$].廠別,[入庫明細$].倉別,[入庫明細$].品名,[入庫明細$].物料編碼,[入庫明細$].單位,0 as 期初數量,0 as 期初金額,0 as 預估入庫數量,0 as 預估入庫金額,[入庫明細$].數量 as 入庫數量,[入庫明細$].金額 as 入庫金額,0 as 預估出庫數量,0 as 預估出庫金額,0 as 出庫數量,0 as 出庫金額,0 as 補料數量,0 as 補料金額,0 as 差異數量,0 as 差異金額 from [入庫明細$] union all select [預估出庫$].廠別,[預估出庫$].倉別,[預估出庫$].品名,[預估出庫$].物料編碼,[預估出庫$].單位,0 as 期初數量,0 as 期初金額,0 as 預估入庫數量,0 as 預估入庫金額,0 as 入庫數量,0 as 入庫金額,[預估出庫$].數量 as 預估出庫數量,[預估出庫$].金額 as 預估出庫金額,0 as 出庫數量,0 as 出庫金額,0 as 補料數量,0 as 補料金額,0 as 差異數量,0 as 差異金額 from [預估出庫$] union all select [出庫明細$].廠別,[出庫明細$].倉別,[出庫明細$].品名,[出庫明細$].物料編碼,[出庫明細$].單位,0 as 期初數量,0 as 期初金額,0 as 預估入庫數量,0 as 預估入庫金額,0 as 入庫數量,0 as 入庫金額,0 as 預計出庫數量,0 as 預計出庫金額,[出庫明細$].數量,[出庫明細$].金額 as 出庫金額,0 補料數量,0 as 補料金額,0 as 差異數量,0 as 差異金額 from [出庫明細$] union all select [補料明細$].廠別,[補料明細$].倉別,[補料明細$].品名,[補料明細$].物料編碼,[補料明細$].單位,0 as 期初數量,0 as 期初金額,0 as 預估入庫數量,0 as 預估入庫金額,0 as 入庫數量,0 as 入庫金額,0 as 預估出庫數量,0 as 預估出庫金額,0 as 出庫數量,0 as 出庫金額,[補料明細$].數量 as 補料數量,[補料明細$].金額 as 補料金額,0 差異數量,0 as 差異金額 from [補料明細$] union all select [差異明細$].廠別,[差異明細$].倉別,[差異明細$].品名,[差異明細$].物料編碼,[差異明細$].單位,0 as 期初數量,0 as 期初金額,0 as 預估入庫數量,0 as 預估入庫金額,0 as 入庫數量,0 as 入庫金額,0 as 預估出庫數量,0 as 預估出庫金額,0 as 出庫數量,0 as 出庫金額,0 as 補料數量,0 as 補料金額,[差異明細$].數量 as 差異數量,[差異明細$].金額 from [差異明細$] |
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2009-12-25 20:43
楼主
