> No it should only return 1 line but even with “and jtype = j.jtype” added to
> the subselect condition it still takes almost 5 minutes to return data

Please provide the PLAN for the statement and the details of indexes defined for the queries tables.


Sean