insert matched value into 3rd table in SP

Question

insert no of matched value as an integer into table3  columns table1 and table2

Susanta Rout · Answer

no there is 4 other column in 3rd table

Shahzad Afzal · Answer

your statement is not clear but some you can get idea like this INSERT INTO table3 SELECT COUNT(*) FROM table1 JOIN table2 ON table2 .[KeyColumn]= table2 .[KeyColumn] assuming that table3 have only one column with type integer