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/11/24 21:33:34
ORA-00936MissingexpressionsqlText="SELECTfv.*,f.lipper_idFROMFund_ValuesfvfundfWHEREfv.fund_id=f.fun

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

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的一段,有错误,大概意思 ex missing missing missing MISSING . missing 意大利语ora ma minu 欧美歌手rita ora外号? tnsnames.ora是什么文件, 借助sqlplus如何查找 spfile.ora,listener.ora ,tnsnames.ora,以及listener.log 的所在位置 Missing you,missing you,nothing but missing Da ora in poi,voi tutti,ti Oracle错误 ORA-12560如何解决 rita ora r.i.p 中英文歌词 双重时间 LA DOPPIA ORA怎么样 Rita Ora - How We Do flac E'la mostra ora incisa sull' anello