Weird sql response, could not explain

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Mon, 26 Jul 2010 16:12:09 -0700
Message-ID: <AANLkTikf6zvfE05hT2+t=PonL=Z549EFv5JxdN5m-aj4_at_mail.gmail.com>

Can someone help me explain this weird behaviour.

when a subquery has a syntactical error what happens to the parent query.

select job_id , job_run_id , job_run_status_id

from job_runs
where dataset_date = trunc(sysdate)
and job_id in

  ( select job_id from load_job_profiles where load_job_profile_id = 33244 ) and job_run_status_id <> 6
...

  1714260   77168858                11
   1714260   77168859                 7
   1714260   77168860                 7
   1714260   77168862                11
   1714260   77168863                 7
   1714260   77168865                 7
   1714260   77168868                11
   1714260   77168869                 7

.....
gives me bunch of results.

where as I run

select job_id from load_job_profiles where load_job_profile_id = 33244

ERROR at line 1:
ORA-00904: "JOB_ID": invalid identifier

Thanks
Deen

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 26 2010 - 18:12:09 CDT