Re: SQL to display hourly count including zero
Posted by:
DJ L
Date: March 31, 2017 07:56PM
FYI if you have a LEFT OUTER JOIN and have a condition on the right hand table, then that condition belongs as part of the JOIN clause and not the WHERE clause. When you include it in the WHERE clause it effectively changes your LEFT OUTER to an INNER JOIN.
Subject
Written By
Posted
Re: SQL to display hourly count including zero
March 31, 2017 07:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.