July 24, 2003 at 7:30 am
I'm coming from MS Access and enjoying it. However I am having an issue that I can't figger out and it seems rather simple.
I try to run this in the Query Analyzer:
UPDATE tblProtocol INNER JOIN tblSponsor ON tblProtocol.tblSponsorFK = tblSponsor.SponsorID
SET tblProtocol.tblSponsorFK = [tblSponsor]![tblSponsorPK]
and I get this:
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'INNER'.
There is probably a simple answer that I am overlooking.
Thanks!
July 24, 2003 at 7:47 am
UPDATE tblProtocol
SET tblProtocol.tblSponsorFK = [tblSponsor]![tblSponsorPK]
from tblProtocol
INNER JOIN tblSponsor ON tblProtocol.tblSponsorFK = tblSponsor.SponsorID
July 24, 2003 at 8:02 am
Thanks! I worked.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply