Basic Update SQL

[DaveL]

Can anyone tell me what I am doing wrong with this basic Update SQL statement?

It seems like a pretty simple problem. I am trying to update a column in FileA (field1) with a column from FileB (field1) where the key fields, field2 and field3, match.

What am I missing?

Thanks!

UPDATE FileA ;
SET field1= ; 
   (SELECT FileB.field1 FROM FileB WHERE FileB.field2= FileA.field2 AND FileB.field3= FileA.field3) ;

 

[carp]

The semicolon at the end of each line is new to me - generally I would only expect to see one at the end of the statement:

UPDATE FileA
SET field1= (SELECT FileB.field1
FROM FileB
WHERE FileB.field2= FileA.field2
AND FileB.field3=FileA.field3) ;

Other than that, this looks OK to me. What kind of error/unexpected results are you getting?

 

[DaveL]

I am trying to run this SQL statement in a Visual FoxPro 6.0 program. The semicolon is a line continuation character. I wanted to make sure the SQL statement itself looked OK. The problem must be specific to VFP. The error I am getting is "Function Name missing )". I must have a problem before the closing ')' because it looks as if it is not seeing it?

I will post the problem on the VFP forum for ideas.

Thanks for the help!!!