Re: Return 0 for data with no matching values

[Peter Brawley]

You need to read about Select syntax.

...from foo f... declares f as an alias for table foo.

select distinct year(datevalue) yr retrieves just one instance of each value set found; `yr` gives it an alias name that can be referenced from a Group By or having clause, or from an outer query.

So that we are no longer working in the dark, post the results of Show Create Table (not Describe Table) for the calendar table and the data table.



Edited 1 time(s). Last edit at 03/23/2015 02:13PM by Peter Brawley.