Select rows from two tables

Question

I have two tables Table1(NameSizeqty) and Table2(NameSizeqty) I want to check Name and Size is equal to or not. If name and size of Table1 equals to Name and Size of Table2 then select row from Table2. Otherwise Select from Table1.

Abhishek Jaiswal · Answer

hey! after creating and inserting values in your table try this Select Name Size from Table t1 INTERSECT select Name Size from Table t2 ON (t1.Name = t2.Name) and (t1.Size = t2.Size) AS begin if ((t1.Name = t2.Name) and (t1.Size = t2.Size)) begin select Name Size from Table2 else select Name Size from Table1 end end

Khan Abrar Ahmed · Answer

Hi you can try like this declare @Table1 as table (Name varchar(64)Size int qty int) declare @Table2 as table (Name varchar(64)Size int qty intt int) insert into @Table1 values ('ABC'12) ('CD'23) insert into @Table2 values ('ABC'122) ('JF'452) select t2.* from @table2 t2 inner join ( select Namesize from @table2 intersect select Namesize from @table1 ) a on a.Name =t2.name and a.size=t2.size union select t1.*null from @table1 t1 inner join ( select Namesize from @table1 except select Namesize from @table2 ) b on b.Name =t1.name and b.size=t1.size