Joining on a common table, how do you get a FULL OUTER JOIN to expand on another table?
- by stimpy77
I've scoured StackOverflow and Google for an answer to this problem.
I'm trying to create a Microsot SQL Server 2008 view. Not a stored procedure. Not a function. Just a query (i.e. a view).
I have three tables. The first table defines a common key, let's say "CompanyID". The other two tables have a sometimes-common field, let's say…