nested select statement.

[PowerX]

hello there,
The sql query taking 47 seconds to excecute, This query may need to be run in my JSP program up to 20 consecutive times looks too long. but it should be possible to use joins instead but not sure how it would work as it is a NOT IN nest rather than an IN nest.

select activity_code,0 from tblactivity where activity_code not in
(select activity_code
from tblAttendance a, tblEvent e
where a.Session_Identity = e.Event_Identity
and e.Event_Start >= '2006/01/01'
and e.Event_Start <= '2006/02/02'
and a.Person_ID = 0099)

Many Thanks, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Renne]

you can try the following:

select activity_code,0
from tblactivity a1
left join
(select activity_code
from tblAttendance a, tblEvent e
where a.Session_Identity = e.Event_Identity
and e.Event_Start >= '2006/01/01'
and e.Event_Start <= '2006/02/02'
and a.Person_ID = 0099) a2
on (a1.activity_code = a2.activity_code)
where a2.activity_code is null

good luck! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --