Saturday, July 24, 2010

Write a SQLquery to update Profit table with GeographyID’s from the following tables –-


                        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


All Rights Reserved @ Raju Das