UPDATE SQL Statement
Posted on 2002-07-14
I am new to SQL and am trying to execute the following statement but my program keeps giving me an error invalid syntax at the "where Documents.BankRoutingNumber = Em". The whole SQL statement looks like this:
strSqlDocLstSeq = "Update Documents, Employees SET SeqNum = " & CheckNumber & _
" where Documents.BankRoutingNumber = Employees.UserRoutingNbr and" & _
" Documents.BankBranchNumber = Employees.UserBranch and Employees.UserLogin = '" & gbl_User_Login & "'" & _
" and Documents.DocType = '" & mstrCashCheck & "'"