Update Query Problem

Results 1 to 2 of 2

Thread: Update Query Problem

  1. #1
    Join Date
    Dec 1969

    Default Update Query Problem

    I&#039;ve got an SQL server dB, but usually write queries in access and then paste into Query analyser <BR>to test and make any minor changes necessary. I having a problem with an update query trying to <BR>update data in 2 tables. The query works in Access but not in SQL server. Any Ideas ?<BR><BR>UPDATE t_Amendments AS pa <BR>INNER JOIN t_Proposal AS p ON pa.PropID = p.PropID <BR>SET pa.ContactDate = Null, p.ApprovalStart = 0<BR>WHERE (((pa.ID)=68));<BR><BR><BR>Thanks in Advance.<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Update Query Problem

    You need to write two update queries, one for each table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts