create a temp table with all the quest_id to be deleted in it.
create table quest_temp as select quest_id from VERSION_ITEM WHERE VERSION_ID = 28831 AND RESP_SCALE_ID = 1 and then selecting from this table in your delete statement.
regards
anandkl
|
Results 1 to 6 of 6
Thread: Preparing Delete ScriptThreaded View
|
Click Here to Expand Forum to Full Width |