delete rows using Merge


delete rows using Merge

I need to merge 2 tables using the merge command , But also I need to delete some row from the target table

so the logic of the merge should be 

1. If rows is located in both source and target tables , Then update 

2. If rows is locted in source table and not in target table then Insert 

3. If rows is located in target and not in source Then delete from target