Problems updating one table from another
This might be long. But here goes. I get a spreadsheet weekly that may update some fields of a database that I want to use to monitor new store openings.
I have tried many iterations of the Update statement, this is the latest attempt:
update "Stores"
SET "Stores"."Type" = "StDevWeekly"."Type",
"Stores"."City" = "StDevWeekly"."City",
"Stores"."State" = "StDevWeekly"."State",
"Stores"."Reg_cnt" = "StDevWeekly"."Reg_cnt",
"Stores"."SO_Date" = "StDevWeekly"."SO_Date",
"Stores"."GO_Date" = "StDevWeekly"."GO_Date",
"Stores"."Last_Day" = "StDevWeekly"."Last_Day",
"Stores"."Field_Tech" = "StDevWeekly"."Field_Tech"
FROM
"StDevWeekly"
Where "Stores"."StNum" = "StDevWeekly"."StNum";
When I run this (or many of the other attempts) I get an error = Column not found: StDevWeekly.Type.
However, when I run simple select queries, it finds it just fine. I even had one that showed both tables fields (with a modified reg_cnt in the stdevweekly table).
Any help would be greatly appreciated. It's been driving me nuts. And most normal SQL tutorials, etc, seem to not work very well in base. :(
My tables are this:
Oh, I am easily able to import the spreadsheet into the StDevWeekly table. (sorry, I forgot that part)