Subject | How can I resolvce this |
---|---|
Author | Hans |
Post date | 2006-11-30T05:17:20Z |
How can I resolvce this
Been using in FB.1.5.3 and lower
DELETE FROM TICKETITEMS WHERE TICKET_UNIQUENUM
NOT IN (SELECT TICKET_UNIQUENUM FROM TICKETS);
it took less than a second
but in FB.2.0.0.0 it never completes.
Thank You
Hans
Been using in FB.1.5.3 and lower
DELETE FROM TICKETITEMS WHERE TICKET_UNIQUENUM
NOT IN (SELECT TICKET_UNIQUENUM FROM TICKETS);
it took less than a second
but in FB.2.0.0.0 it never completes.
Thank You
Hans