<br /><font face="sans-serif" size="2">I want to delete certain rows from table USER_TBL. </font><br /><font
face="sans-serif"size="2">Two tables are involved. USER_TBL and OWNER_TBL. </font><br /><br /><font face="sans-serif"
size="2">Theentries that match BLAND type in OWNER table and who also have a matching entry in USER table NAME but
onlyfor USER_TBL entries with places equal to HOME. </font><br /><br /><font face="sans-serif" size="2">DELETE FROM
SP.TST_USER_TBLWHERE EXISTS</font><br /><font face="sans-serif" size="2"> (SELECT SP.TST_USER_TBL.NAME FROM
SP.TST_USER_TBL,SP.TST_OWNER_TBL WHERE TYPE='BLAND' AND PLACE='HOME' AND SP.TST_OWNER_TBL.NAME=SP.TST_USER_TBL.NAME)
</font><br/><br /><br /><font face="sans-serif" size="2">Example :</font><br /><br /><font face="sans-serif" size="2">
<b>OWNER_TBL</b> <b>USER_TBL</b></font><br /><br /><font face="sans-serif"
size="2"> <u> NAME TYPE PLACE NAME</u></font><br /><font
face="sans-serif"size="2">BLAND BLAND WORK BLAND</font><br /><font
face="sans-serif"size="2">LARRY BLAND HOME BLAND</font><br /><font
face="sans-serif"size="2">MOE BLAND HOME LARRY</font><br /><font
face="sans-serif"size="2">CURLY BLAND WORK LARRY</font><br /><font
face="sans-serif"size="2">JOE BLAND HOME MOE</font><br /><br /><br
/><fontface="sans-serif" size="2">In the end I expect the USER_TBL to <b>not </b>contain the 3 HOME entries.
</font><br/><font face="sans-serif" size="2">But what is happening is the whole USER_TBL is empty after the query.
</font><br/><br /><font face="sans-serif" size="2">Any ideas or tips.. Thanks.</font>