Skip to Content
Jun 13, 2016 at 08:23 AM

Data correlation between database and report level


Hi All,

I have two tables calendar look up and shop facts.

If I make a inner join between two tables,I will get matching data between two tables i.e.,

2004,2005,2006 sales revenue.

And If I make a left outer join between two tables( LOJ on calendar look up),I will get all data from

calendar look up (2002,2003,2004,2005,2006) ,null and matching data from right side table i.e., 2002,2003_null data and

2004,2005,2006 sales revenue.

But when I run the below sql statement in MS SQL Server database,I'm getting all years(2002,2003,2004,2005,2006) sales revenue and I didn't get null values for 2002,2003.

select year,amount sold

from calendar look up ,shop facts.

Kindly help me over the concern .