Column not found in SQL UPDATE

[Morgan P]

Hi
I have a database "UK Postcodes" with two tables "Population and Households" and "Types"
Table "Population and Households" has columns "SpacelessPostcode" and "MosaicType" (MosaicType values currently null), amongst others and table "Types" has columns "SpacelessPostcode" and "MosaicUK6_Type"
I'm attempting to copy an integer value from column "MosaicUK6_Type" in table "Types" to "MosaicType" in Table "Population and Households" for rows where the "SpacelessPostcode" columns are equal.
Here is my SQL;

UPDATE "Population and Households"
SET "MosaicType" = "Types"."MosaicUK6_Type"
FROM "UK Postcodes"
WHERE ("SpacelessPostcode" = "Types"."SpacelessPostcode")

but I'm getting the error;
Column not found: Types.MosaicUK6_Type
What am I doing wrong?

[chrisb]

the solution is shown here>> viewtopic.php?p=389753#p389753