Re: JOIN Usage
Sean S wrote:
> That give me one of the many results with 0 for the count. It seems like this should work, but
> for some reason, if the dispositionID doesn't appear with the records between the two dates it
> doesn't show up. But even if I pull the date restriction is still doesn't show all of the
> results from the Dispositions table.
What do you get when you completely remove your where clause?
Since you want *all* your dispostion records in the resultset, you cannot have a where clause on columns from the Calls table.
--
felix
Subject
Written By
Posted
Re: JOIN Usage
May 03, 2005 12:16PM
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.