I have 1 query from table1 as follows
Query1
select id1, id2, name1, address1 from table1 where name1=@name1
I have another table table2 which contains columns from table1 as follows
columns of table2
idd1 pk
id1 (from table1)
name1 (from table1)
I wanted to update Query1 such that is the values of id1 and name1 from table1 found in table2, query1 should not select those columns
Go to the complete details ...