DELETE WHERE EXISTS unexpected results
От | Jeff Bland |
---|---|
Тема | DELETE WHERE EXISTS unexpected results |
Дата | |
Msg-id | OF34A9AF8F.539E0789-ON852577EB.0077F498-852577EB.007A650B@us.ibm.com обсуждение исходный текст |
Ответы |
Re: DELETE WHERE EXISTS unexpected results
|
Список | pgsql-sql |
<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>
В списке pgsql-sql по дате отправления: