Hi Guys,
Please take a look at this update statement and guide me as to what am I doing wrong:
update orders set
orders.state_key = geography.state_key
where
orders.geography_key = geography.geography_key;
when I run this statemnt I get the following error:
orders.geography_key = geography.geography_key
*
ERROR at line 4:
ORA-00904: "GEOGRAPHY"."GEOGRAPHY_KEY": invalid identifier
Appreciate you input,
Chintz