SELECT Id,Name, ( SELECT Salary FROM Tab2 WHERE Tab1.Id=Tab2.Id) AS Salary FROM Tab1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)