Comparing table with sql/tsql in sql server 2012 : I have Four tables in sql server 2012, table1, table2, table3, and a (resultant/output table) table4 

1) table1 is truncated and loaded with new data daily.

2) table1 columns col1,col2,col3 are similar to table2 columns col7,col18,col9  and table1 columns col1,col2,col3 are similar table3 col9,col11,col7


Problem 
---
loop table1 to check for every row (col1,col2,col3) matches any row in the table2 (col7,col18,col9) then add row in table4 containing information table1.col1,table1.col2,table1.col3, table2.col6,table3.col1,table3.col7 and a column to indicate its an update

if row (col1,col2,col3) in table1 does not exist in table2 add row in table4 containing information table1.col1,table1.col2,table1.col3, table2.col6,table3.col1,table3.col7 and a column to indicate its an addition

if row (col7,col18,col9) in table2 does not exist in table1 add row in table4 containing information table1.col1,table1.col2,table1.col3, table2.col6,table3.col1,table3.col7 and a column to indicate its an deletion

1) return table4 as result

How can we do this with SQL/TSQL only.
