update and inner join - sintax question

[Guest_imported]

update file1 inner join file2
on file1.field = file2.samefield
set file1.field2 = file2.samefield2
where file1.field2 = ' YES '
I've got syntax problem.
Any suugestion would be appreciate.

 

[tlbroadbent]

Try the following.

Update file1
Set field2 = file2.samefield2
From file1 inner join file2
On file1.field = file2.samefield
Where file1.field2 = ' YES ' Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[carp]

I think you need a SELECT in the subquery:

Update file1
Set field2 = SELECT file2.samefield2
From file1 inner join file2
On file1.field = file2.samefield
Where file1.field2 = ' YES ';

 

[Guest_imported]

thanks to everyone who's responded.