UPDATE Table2
SET Table2.integerfield = 1
FROM Table 1
INNER JOIN Table2 ON Table1.textfield = Table2.textfield
-----Original Message-----
From: Raster, Tim [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 15:44
To: SQL
Subject: RE: Big honkin' query gettin' me down!
I think that was turned around. Try:
UPDATE Table1
SET Table2.integerfield = 1
FROM Table 1
INNER JOIN Table2 ON Table1.textfield = Table2.textfield
-----Original Message-----
From: Scott Weikert [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 16:02
To: SQL
Subject: Re: Big honkin' query gettin' me down!
Maureen writes:
> UPDATE Table1 INNER JOIN Table2 ON Table1.textfield = Table2.textfield
SET
> Table2.integerfield = 1;
Error:
Incorrect syntax near the keyword 'INNER'.
I don't think you can put two table names in the "UPDATE" part of the
query...?
________________________________
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
