是的,sqlserver。
SQL错误: select
t1."ContractName",
t1.ContractValue,
t1."hysicalIndicator1",
t1."Converting1",
t1."hysicalIndicator2",
t1."Converting2",
t1."StartDate",
t1."EndDate",
t1."ContractPeriod",
t1."rovince",
t1."Area",
t1."SignDate",
t1."NewIndustryType",
t1."BusinessMode",
t1."ContractState",
t1."CustomerName",
t1."BuildUnit",
t2."artyAName",
t2."artyBName",
t3.*
from
"OA"."dbo"."MM_ContractEntity" t1
left join "ceec_stencil"."dbo"."ceec_stencil_copy1" t3 on t1.ContractName = t3.contract_name
left join "OA"."dbo"."DAMS_ContractArcFileEntity" t2 on t1.ContractName = t2.ContractName
where
t1."ContractCode" is not null
and 1=1
and left(convert(varchar(15), dates, 23), 7) = '202310';Query failed (#20231031_063452_00755_f7w3k): line 29:9: mismatched input 'left'. Expecting: