|
楼主 |
发表于 2018-7-2 06:15:40
|
显示全部楼层
SELECT TOP (100) PERCENT BG_FormBGDatas_1.cFormCode, dbo.GL_accsum.md, dbo.GL_accsum.mc,
BG_FormBGDatas_1.fPeriod1, BG_FormBGDatas_1.fPeriod2, BG_FormBGDatas_1.fPeriod3,
BG_FormBGDatas_1.fPeriod4, BG_FormBGDatas_1.fPeriod5, BG_FormBGDatas_1.fPeriod6,
BG_FormBGDatas_1.fPeriod7, BG_FormBGDatas_1.fPeriod8, BG_FormBGDatas_1.fPeriod9,
BG_FormBGDatas_1.fPeriod10, BG_FormBGDatas_1.fPeriod11, BG_FormBGDatas_1.fPeriod12, dbo.GL_accsum.iperiod,
dbo.GL_accsum.iyear, BG_FormBGDatas_1.cItemCode
FROM dbo.BG_FormBGDatas AS BG_FormBGDatas_1 INNER JOIN
dbo.GL_accsum ON BG_FormBGDatas_1.cItemCode = dbo.GL_accsum.ccode
WHERE (dbo.GL_accsum.ccode >= N'6001') AND (dbo.GL_accsum.iyear = 2018)
ORDER BY dbo.GL_accsum.ccode
上面语句是我现在新建的一个视图单账套的视图,想要添加进去UFDATA_500_2016/UFDATA_501_2016等等账套,这个语句应该怎么编写?谢谢
|
|