| SELECT * FROM dbo.[煤矿、金属非金属矿山等工矿企业安全生产事故隐患排查治理情况月报表] where 行业与领域='煤矿企业' and left("填报日期",4)=${year(today())} and IF(LEN("填报日期")=10,MID("填报日期",6,2),MID("填报日期",6,1))=${month(today())} 请问这一个数据集查询哪里有问题 |
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
