select * from table1 inner join table2 on table1.id = table2.id
SELECT t1.id, t1.name, t1.city , t2.address FROM [YourDatabaseName].[dbo].[table1] AS t1 LEFT JOIN [YourDatabaseName].[dbo].[table2] AS t2 on t1.id = t2.id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)