作业帮ORA-00936 Missing expressionsqlText = "SELECT fv.*, f.lipper_id FROM Fund_Values fv fund f WHERE fv.fund_id=f.fund_id AND fv.Effective_date = '" & Cells(j, 2).Value & "' AND fv.Fund_id = " & Cells(j, 4).Value这是vba的一段,有错误,大概意思
来源：学生作业帮助网 编辑：作业帮 时间：2024/05/06 17:46:11
ORA-00936 Missing expressionsqlText = "SELECT fv.*, f.lipper_id FROM Fund_Values fv fund f WHERE fv.fund_id=f.fund_id AND fv.Effective_date = '" & Cells(j, 2).Value & "' AND fv.Fund_id = " & Cells(j, 4).Value这是vba的一段,有错误,大概意思
ORA-00936 Missing expression
sqlText = "SELECT fv.*, f.lipper_id FROM Fund_Values fv fund f WHERE
fv.fund_id=f.fund_id AND fv.Effective_date = '" & Cells(j, 2).Value
& "' AND fv.Fund_id = " & Cells(j, 4).Value
这是vba的一段,有错误,大
概意思从取fv表所有,f表的lipper_id,但要符合fv表和f表的主键fv.fund_id=f.fund_id,而且同时符合fv表的
Effective_date为cells（j,2).和Fund_id等于excel的cells（j,4)
请大侠赐教
ORA-00936 Missing expressionsqlText = "SELECT fv.*, f.lipper_id FROM Fund_Values fv fund f WHERE fv.fund_id=f.fund_id AND fv.Effective_date = '" & Cells(j, 2).Value & "' AND fv.Fund_id = " & Cells(j, 4).Value这是vba的一段,有错误,大概意思
FROM Fund_Values fv(就是这个地方你少个逗号)fund f