Re: SQL question
From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Wed, 24 Oct 2012 16:13:17 -0400
Message-ID: <CAEpg1wB39Et_97HCG3ca-_KffbNxktN6A5ZKgRC4-q9X1mMH_g_at_mail.gmail.com>
<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.
Date: Wed, 24 Oct 2012 16:13:17 -0400
Message-ID: <CAEpg1wB39Et_97HCG3ca-_KffbNxktN6A5ZKgRC4-q9X1mMH_g_at_mail.gmail.com>
<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 Wed Oct 24 2012 - 22:13:17 CEST