I have the following table
I have inserted Product B to it and it gives me an ID of 15
Then I have the definition table which is as follows.
I want to select the ProductDefinition rows where ProdID = 14 and replicate the same and insert it for ProdID = 15 like the following
How to achieve this using SQL code?
INSERT INTO ProuctDefinition (ProdID, Definition, Desc) SELECT xxx, Definition, Desc FROM ProductDefinition WHERE ProdID = yyy
xxx is your new ProdID and the
yyy is your old one. This also assumes that
DefID is automagically populated on