Punit Jain Posted April 27, 2006 Share Posted April 27, 2006 I have two tables with 1 common field.I have to update the value of column1.1 in table1 by the values of column2.1 from table2.The prblem is table1 does not have a primery key it has a composite key(column1.1,column1.2).Please try to find out the solution.Thanks Link to comment Share on other sites More sharing options...
justsomeguy Posted April 27, 2006 Share Posted April 27, 2006 Please post the schema for both tables. Link to comment Share on other sites More sharing options...
Punit Jain Posted April 28, 2006 Author Share Posted April 28, 2006 I have two tables with 1 common field.I have to update the value of column1.1 in table1 by the values of column2.1 from table2.The prblem is table1 does not have a primery key it has a composite key(column1.1,column1.2).Please try to find out the solution.Thanks<{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Punit Jain Posted April 28, 2006 Author Share Posted April 28, 2006 I have two tables with 1 common field.I have to update the value of column1.1 in table1 by the values of column2.1 from table2.The prblem is table1 does not have a primery key it has a composite key(column1.1,column1.2).Please try to find out the solution.Thanks<{POST_SNAPBACK}> Thanks for your attention towards the problem.I have found the solution.Thanks & RegardsPunit Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now