Profit table Geography table
SKGeographyID | Geography | ProfitValue |
Europe | 500 | |
America | 600 | |
Singapore | 700 | |
Japan | 800 | |
England | 900 |
SKGeographyID | Geography |
1 | Europe |
2 | America |
3 | Singapore |
4 | Japan |
5 | England |
Update Profit P set P.SKGeographyID = Geogrpahy. SKGeographyID where P.Geography = Geogrpahy.Geography
No comments:
Post a Comment