Anthony stark Posted September 10, 2019 Share Posted September 10, 2019 Hi guys I am trying to add a single column to a data table without changing the total amount of records in current table, so i can compare the new column with a current column in the existing table. Whats the best way to approach this Any help i appreciated. Thanks Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted September 10, 2019 Share Posted September 10, 2019 Best approach will depend on the datasets. You can insert column to table 1, match on relevant column and select left single match which will fetch one record inthat column. This way number of records would not increase in table1. Again to take this approach or not will depend on how the data is present in both tables. Link to comment Share on other sites More sharing options...
Anthony stark Posted September 10, 2019 Author Share Posted September 10, 2019 Thanks Khushboo, i appreciate it 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