I have a table which is formatted in this way -
Col1 --- Col 2 Code --- Article
However One 'code' may be repeated multiple times but with a different Article. Its always unique though so I will never had a 'Code' with the same 'article' twice.
There are some 'default' articles (around 6 defaults) that I want to insert into the table so that every 'Code' has these default 'Article'.
However some of the Codes might already have these default Articles so I wish to ignore them.
I am scratching my head at how I can do this so looking for some help if possible.