SELECT database1.dbo.table1.*, database2.table2.*, database3.dbo.table3.* FROM database1.dbo.table1 JOIN database2.dbo.table2 ON database1.dbo.table1.hid = database2.dbo.table2.hid JOIN database3.dbo.table3 ON database3.dbo.table3.hid =database2.dbo.table2.hid JOIN database3.dbo.table3 ON database3.dbo.table3 .hid = database1.dbo.table1.hid
SELECT Distinct T1.Col1, T1.Col2, T1.Col3, T2.col1, T2.Col2 T3.Col1, FROM database1.dbo.table1 t1 INNER JOIN database2.dbo.table2 T2 ON T1.hid = T2.hid INNER JOIN database3.dbo.table3 T3 ON T2.hid =T3.hid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)