AID | Title ----------------- 1 | Technology 2 | Science 3 | Asp.net
AID | WID | Matching ------------------------ 1 | 1 | 17 1 | 4 | 19 2 | 5 | 22 3 | 6 | 25
AID | Title | WID | Matching ------------------------------------------ 1 | Technology | 1 | 17 1 | Technology | 4 | 19 2 | Science | 5 | 22 3 | Asp.net | 6 | 25
select AID,Title,WID,Matching from table1 inner join table2 on AID.table1=AID.table2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)