On 7 Oct 2004 17:11:44 -0700, joel-garry_at_home.com (Joel Garry) wrote:
>Jeff Kish <jeff.kish_at_mro.com> wrote in message news:<9fcam0lf14qg9jdbb7ahjj3qdm7ni0p8p2_at_4ax.com>...
>> Could someone explain how this is processed by the database?
>>
>> I'm having trouble formulating these correctly because I don't quite
>> understand how the database processes exists.
>>
>>
>> select count(*) from table1
>> where (locationid like '%SOMEVALUE1%') and (exists (select job from table2
>> where (( contains(description,' $Carpenter ') > 0 )) and (job
>> in (select job from jobtable where job is not null and
>> locationid=table1.locationid))))
>>
>>
>> Actually if there is a good explanation on how to methodically take these
>> suckers apart and figure
>> out how the database processes them that'd be fine also.
>
>http://asktom.oracle.com/pls/ask/f?p=4950:8:18436658121816782799::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:953229842074,
>
>is pretty informative.
>
>jg
Thanks
Jeff Kish
Received on Fri Oct 08 2004 - 07:01:02 CDT
