查询表里面下面提示要用{}把表名框起来，我没框起来 也可以执行呢是咋回事，我直接把mssql的视图复制了 就可以用，这后面不会有问题吧
SEL。ECT dbo.原始凭证.原始凭证编号, dbo.原始凭证.审核流程状态, dbo.原始凭证.所属项目名称, dbo.agreement.agreementName, dbo.flow.flowMainCode, dbo.flow.flowMain, dbo.flow.flowLimitIds,
dbo.DD.value, dbo.DD.text, dbo.原始凭证.原始凭证类型, dbo.原始凭证.金额, dbo.原始凭证.录入人员, dbo.原始凭证.生成时间, dbo.flow.flowCode, dbo.flow.flowName, dbo.flow.isOver,
dbo.原始凭证.贷方 AS 贷方代码, partner_1.partnerName AS 贷方名称, dbo.原始凭证.借方 AS 借方代码, dbo.partner.partnerName AS 借方名称, dbo.原始凭证.摘要
FROM dbo.原始凭证 LEFT OUTER JOIN
dbo.DD ON dbo.原始凭证.原始凭证类型 = dbo.DD.value LEFT OUTER JOIN
dbo.partner ON dbo.原始凭证.借方 = dbo.partner.partnerCode LEFT OUTER JOIN
dbo.partner AS partner_1 ON dbo.原始凭证.贷方 = partner_1.partnerCode LEFT OUTER JOIN
dbo.flow ON dbo.原始凭证.审核流程状态 = dbo.flow.flowMainCode LEFT OUTER JOIN
dbo.agreement ON dbo.原始凭证.所属项目名称 = dbo.agreement.agreementCode
加好友 
发短信
Post By：2020/3/9 13:14:00 [显示全部帖子]
