update table

[Ratzie]

I can not seem to get this to work.
update table1
set table1.cola ='PEPSI'
where table2.feature = 'PEPSI TYPE'
and table1.master_key = table2.master_key

So I am updating the main table if the second table contains the right data.

[Aussan]

Try " instead of '

example "PEPSI"

[Aussan]

here is the example

UPDATE table1
SET table1.cola="PEPSI"
WHERE tabel2.feature = "PEPSI TYPE" AND table1.master_key=table1.master_key

[Aussan]

here is the example

UPDATE table1
SET table1.cola="PEPSI"
WHERE tabel2.feature="PEPSI TYPE" AND table1.master_key=table1.master_key

[Aussan]

what happend?

[TwoProc]

What error do you get?

[Ratzie]

same error
I have never used double quotes around values

[Ratzie]

invalid sql statement

[Aussan]

what's the error??

[Aussan]

could you cut and past the exact syntax you are using, and also the error does it point at the exact line the error is or no