select bh AS 单号,chrq AS 日期, khbh AS 客户ID,czyid AS 操作员, yfje AS 应付金额,sfje AS 实付金额
, djlx AS 单据类型
from ch_zdj
union
select bh AS 单号,thrq AS 日期, khbh AS 客户ID,czyid AS 操作员, yfje AS 应付金额,sfje AS 实付金额
, djlx AS 单据类型
from th_zdj
as
AAA
select AAA.单号, AAA.日期,UN.操作员,AAA.应付金额,AAA.实付金额,AAA.单据类型,kh.mc AS 名称 from UN
join kh
on kh.bh=AAA.客户ID
//错误原因:union跟select成为单独两条语句
正确语句:
select AAA.单号, AAA.日期,AAA.操作员,AAA.应付金额,AAA.单据类型,czy.mc from
(select bh AS 单号,chrq AS 日期, khbh AS 客户ID,czyid AS 操作员, yfje AS 应付金额,sfje AS 实付金
额, djlx AS 单据类型
from ch_zdj
union
select bh AS 单号,thrq AS 日期, khbh AS 客户ID,czyid AS 操作员, yfje AS 应付金额,sfje AS 实付金额
, djlx AS 单据类型
from th_zdj
)
as
AAA
join czy
on
AAA.操作员=czy.id
where
czy.id=1
select kh.mc AS 名称,ch_zdj.bh AS 单号,ch_zdj.chrq AS 日期, ch_zdj.yfje AS 应付金额,ch_zdj.sfje
AS 实付金额, ch_zdj.djlx AS 单据类型,czy.mc AS 操作员
from ch_zdj
join kh
on kh.bh=ch_zdj.khbh
join czy
on czy.id=ch_zdj.czyid)
union
select kh.mc AS 名称,th_zdj.bh AS 单号,th_zdj.thrq AS 日期, th_zdj.yfje AS 应付金额,th_zdj.sfje
AS 实付金额, th_zdj.djlx AS 单据类型,czy.mc AS 操作员
from th_zdj
join kh
on kh.bh=th_zdj.khbh
join czy
on czy.id=th_zdj.czyid)
where
名称='洛阳'
//错误原因:不能有where条件,因条件字段难以确定
学习中遇到的问题,记录备忘!