missing SET keyword

[jestin]

hi friends i am trying to upadate oracle table value by using inner join method

and the ASP code is as follows

 
sqlupdate = "UPDATE Tbl_RequestInfo INNER JOIN Tbl_RequestSched ON Tbl_RequestInfo.ReqID = Tbl_RequestSched.RschedReqid SET " &_
	"Tbl_RequestSched.RschedStatus =" & STR_Quote2(ReplaceQuote(newstatus)) &_
	", Tbl_RequestSched.RschedUpdatedby =" & STR_Quote2(ReplaceQuote(session("username"))) &_
	", Tbl_RequestSched.RschedUpdatedlast =" & curdate &_
	", Tbl_RequestInfo.ReqStatus =" & STR_Quote2(ReplaceQuote(newstatus)) &_
	", Tbl_RequestInfo.ReqRemarks =" & STR_Quote2(ReplaceQuote(textremarks)) &_
	'", ReqUpdatedLastby=" & STR_Quote2(ReplaceQuote(session("username"))) &_
	", ReqUpdatedLast=" & curdate &_
	" WHERE (((Tbl_RequestInfo.ReqID)=" & ReplaceQuote(textrequestID) & ") " &_
	"AND ((Tbl_RequestInfo.ReqServicetypeid)=" & ReplaceQuote(textservicetype) & ") " &_
	"AND ((Tbl_RequestInfo.ReqFuncloc)=" & STR_Quote2(ReplaceQuote(textfuncloc)) & "))"

and i get the error message is as follws

missing SET keyword
if u have any sln, then plz

[shweta123]

Hi,

I think you are getting this because , you can not use Update with multiple tables join. You have to use Triggers or some other way for that.

[jhardman]

Hi,

I think you are getting this because , you can not use Update with multiple tables join. You have to use Triggers or some other way for that.

Yeah, or use a stored procedure.

Jared