Sql

[y123]

Hi,

I,m trying to query Oracle DB thru SQLplus:


I'm qureying 2 diff tables, where the field in table one in not in table 2.

When I use the following query, sqlplus hangs all the time

Query:

SELECT A.POSITION_NBR
,A.ROWSECCLASS
,A.ACCESS_CD
,A.DESCR
,B.EMPLID
,B.NAME
,A.POSN_STATUS
,A.BUSINESS_UNIT
,A.DEPTID
,A.JOBCODE
,A.REPORTS_TO
,'FRESI'
FROM PS_POSITION_srch A
,ps_fm_posn_incmbnt b
WHERE a.position_nbr not in b.position_nbr

any help is appreciated.Thanks