Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SELECT problems..WHERE x not in list not working??
Hi all,
Maybe I'm just brain farting...but, I cannot for the life of me figure out why a simple query isn't working.
select a.projectname, NVL(d.catalognumber,'NULL') catalognumber,
d.title course_title, e.title template_title
from project a, projecttrainingneed b, candidatecourse c, course d,
categorytemplate e
where a.projectid = b.projectid
and b.projecttrainingneedid = c.projecttrainingneedid and c.courseid = d.courseid and a.categorytemplateid = e.categorytemplateidand upper(a.projectname) not in
But, on my results...I still get rows with Oceana, Lakehurst and Pensacola in them. Any clues as to why the NOT IN statement list with wildcards isn't working?
tia,
chilecayenne Received on Tue May 30 2006 - 16:15:26 CDT