All,
I am far from expert with SQL and have been unable to solve the
following problem (stated in generic terms):
I have three tables:
1. Employees - contains EmployeeName
2. Years - contains Year
3. Earnings - contains Year, EmployeeName, and Earnings
I need a query that will return a row with the Year, EmployeeName, and
Earnings for every possible combination of Year and EmployeeName, even
if that combination does not appear in the Earnings table.
If it matters, I am using SQL Server 2005.
Can you help me?