× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



We have the following SQL query, that works very well:

select year,
month,
sum(sales) as sales
from foo
where (year * 100 + month) > ((year(current_date) -1) * 100 +
month(current_date))
group by year, month
order by year, month

But now, we want to add a fourth column, for the previous year's sales. Now, I can get this by itself (I think) with something like this:

select year+1 as year,
month,
sum(sales) as py_sales
from foo
where ((year * 100 + month) > ((year(current_date) -2) * 100 + month(current_date)))
and ((year * 100 + month) <= ((year(current_date) -1) * 100 + month(current_date)))
group by year, month
order by year, month

But how would I combine these to get both the "sales" and "py_sales" columns? Some kind of a join, maybe? But what would the syntax be?

--
JHHL

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.