Hi All, I have one new table named IBC which contains the below columns: Model1 Model2 Model3 Model4 Model5 Model6 Model7 ResultingModel ResultingIBType ID I have one old table named XYZ which contains Equipment type and IB type columns. The difference between the 2 tables is that the old table contains Equipment type values as concatenated. For ex: the value is (GRAVROL - 3 , UNCLASSIFIED - 3) But in the new table the value is like below: Column Model1= Gravrol Column Model2=Unclassified and the value in ResultingModel column value is Gravrol. So ideally i need an update query which will replace the Equipment value GRAVROL - 3 , UNCLASSIFIED - 3 to the new value Gravrol and add a column to the old table showing the old Equipment value. How can this be achived?
I think you are asking to create a new table(XYZ) from old table(IBC) with same data, If my assumption is right then here is the answer. 1) You need to drop the new table(XYZ) by using **DROP TABLE XYZ** 2)Now you will create the new table by name XYZ and copy all the data from old table(IBC) by using **SELECT * INTO XYZ FROM IBC** This time you will get the expected output in the new table(XYZ)