Syntax Error

  • 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!

  • UPDATE tblProtocol

    SET tblProtocol.tblSponsorFK = [tblSponsor]![tblSponsorPK]

    from tblProtocol

    INNER JOIN tblSponsor ON tblProtocol.tblSponsorFK = tblSponsor.SponsorID

  • 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