Re: SQL question
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Wed, 24 Oct 2012 16:43:52 -0600
Message-ID: <50886F28.7060609_at_gmail.com>
Exactly my point.
In theory it should not, if ID is an enforced primary key. But ...
Date: Wed, 24 Oct 2012 16:43:52 -0600
Message-ID: <50886F28.7060609_at_gmail.com>
Exactly my point.
In theory it should not, if ID is an enforced primary key. But ...
One additional question, based on further posts, is: are these queries on the same DB?
/Hans
On 24/10/2012 2:13 PM, Rumpi Gravenstein wrote:
> <snip>
> Theoretically table3 should not be required in the join
> </snip>
>
> Table 3 may be acting as a filter in which case it will impact the
> final count.
>
> Rumpi Gravenstein
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 25 2012 - 00:43:52 CEST