I have two sample tables attached tbl1 and tbl2. What I am trying to do is:
1. append and update the new [NumName] entries that appear in tbl1 into tbl2 with their [NumName] and [Size] respectively. I currently have the below query which isn't working
Exists (SELECT * FROM tbl1 WHERE tbl2.NumName=tbl1.NumName)
2. I also need to update existing records in tbl2 based on the [NumName] and [Size] values having changed in tbl1
Your help is much appreciated in advance.