[dba-SQLServer]Update sproc

I am trying to create a sproc in SQL2K that will update records.

I have the following code:

 

UPDATE tblCheckRequest 

INNER JOIN tblCharges ON (tblCheckRequest.ClaimNo = tblCharges.ClaimNo)
AND (tblCheckRequest.EndServDate = tblCharges.EndServDate) AND
(tblCheckRequest.CPT = tblCharges.CPT) AND (tblCheckRequest.DupCode =
tblCharges.DupCode) AND (tblCheckRequest.ProvNo = tblCharges.ProvNo) AND
(tblCheckRequest.PatientNo = tblCharges.PatientNo) 

SET tblCharges.PaidCode = 'CP', tblCharges.PaidDate = Int(Now());

 

When running this code, I receive the following message:

"Incorrect syntax near the keyword 'INNER'".

Should I not be using 'INNER JOIN ..'?

Very confused.

 

Any help is greatly appreciated.

Thanks,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030211/afa6711f/attachment.html>