Update statement problem

From: Vlad (vovan.c_at_verizon.net)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 11:39:58 -0400

I'm rewriting SQL statements used in Access in order to use them with SQL
Server.
This SQL works with Access, but says 'incorrect syntax near RIGHT keyword':

UPDATE [Partial] RIGHT JOIN BillPayment ON [Partial].PartialID =
BillPayment.PartialID SET [Partial].MfrPaidAmount =
[Partial].MfrPaidAmount - BillPayment.AppliedAmount, [Partial].MfrPaidInFull
= 0 WHERE BillPayment.PaymentID = 9698

Statement is executed from VB6 app.
What's wrong with it?
Thank you
Vlad

Relevant Pages

  • Please Help with Transaction + Alter Procedure statement
    ... I am struggling with the following SQL. ... Incorrect syntax near the keyword 'PROCEDURE'. ... Must declare the variable '@mySomething'. ...
    (microsoft.public.sqlserver)
  • Re: Incorrect syntax near the keyword Close
    ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > Incorrect syntax near the keyword 'Close'. ...
    (microsoft.public.sqlserver.server)
  • Problem SQL ADO
    ... Using Python on WinXP going against MS SQL 2000 server. ... Provider for SQL Server', "Incorrect syntax near the keyword 'INNER'.", ...
    (comp.lang.python)
  • Re: Help I am getting an error when I run my insert statement
    ... Microsoft OLE DB Provider for SQL Server error '80040e14' ... Incorrect syntax near the keyword 'Plan'. ... startdate, finshdate,revfinish are all smalldatetime ...
    (microsoft.public.sqlserver.odbc)
  • Re: Parameter for Stored Procedure
    ... Incorrect syntax near '@ClientDBName'. ... FILENAME = N''C:\Program Files\Microsoft SQL ... MAXSIZE = UNLIMITED, ... FILEGROWTH = 1024KB) ...
    (comp.databases.ms-sqlserver)