So what you need is view in your sql server that does a join. 

This page should help you with a high level over view of a basic join. http://www.w3schools.com/sql/sql_join.asp

The hard part will be finding a common piece of data between the tables to associated each entry. I'd also suggest wrapping your join statement in another select statement so that you can do a SELECT DISTINCT and get rid of any duplicates. 

This is an example:

SELECT DISTINCT *
FROM (
SELECT 
	
	[Table1].Column1 as CO1, 
        [Table2].Column1 as CO2,
        [Table2].Column2 as CO3


	FROM [Table1]
        LEFT JOIN [Table2]

        On [Table1].MatchingColumn = [Table2].MatchingColumn

	) O
	ORDER BY CO1, CO2

The reason I enclose it all is so that I can get rid of any duplicates that might occur and I also do an Order By simply for ease of use when looking at the view. 

Once you've tested that you can insert your query you can then insert it into a view, instructions for that are here:  http://www.w3schools.com/sql/sql_view.asp

This view is what you will actually query. 

You will want to make sure you don't get too many results with your queries. A left join will return all rows with column 1 plus all columns that match (as determined by the ON clause). If there is a column1 that doesn't match it will return a NULL (which will be interpreted as blank) on the other columns. 

Be careful as it can make for some very large queries!