是的，sqlserver。
SQL错误: select
t1."ContractName",
t1.ContractValue,
t1."PhysicalIndicator1",
t1."Converting1",
t1."PhysicalIndicator2",
t1."Converting2",
t1."StartDate",
t1."EndDate",
t1."ContractPeriod",
t1."Province",
t1."Area",
t1."SignDate",
t1."NewIndustryType",
t1."BusinessMode",
t1."ContractState",
t1."CustomerName",
t1."BuildUnit",
t2."PartyAName",
t2."PartyBName",
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:
地理智能赋能业务，函数实战夯实基础，新春活动智趣相融——一月下旬，与数据共赴新年新征程！
