Post reply

Updating records with a join.

  • December 16, 2004 at 12:22 pm

    #84391

    In Access I would use the statement:

    UPDATE tblSite INNER JOIN tblSiteReview ON tblSite.tblSitePK = tblSiteReview.tblSiteFK SET tblSiteReview.blnNonCompliant = True

    WHERE (((tblSite.intStatus)=2) AND ((tblSiteReview.dtmReviewDate)>[tblSiteReview].[dtmExpDate]));

    How would I run the same statement in SQL Server?

     

    Thanks!

  • December 16, 2004 at 12:25 pm

    #534218

    UPDATE tblSiteReview

    set tblSiteReview.blnNonCompliant = 1

    from tblSite inner join tblSiteReview on tblSite.tblSitePK = tblSiteReview.tblSiteFK

    where (((tblSite.intStatus)=2) AND ((tblSiteReview.dtmReviewDate)>[tblSiteReview].[dtmExpDate]))

    If the phone doesn't ring...It's me.

  • December 16, 2004 at 12:27 pm

    #534221

    UPDATE tblSiteReview SET tblSiteReview.blnNonCompliant = True

    from tblSite,tblSiteReview--,INNER JOIN tblSiteReview ON tblSite.tblSitePK = tblSiteReview.tblSiteFK

    WHERE (((tblSite.intStatus)=2) AND ((tblSiteReview.dtmReviewDate)>[tblSiteReview].[dtmExpDate]))

    JR

  • December 16, 2004 at 12:54 pm

    #534233

    Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply