Timeline for delete records in one table based on multiple column values in second table
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 23, 2015 at 21:00 | comment | added | Dave Jones | @Chris: I'm afraid that syntax is Postgres specific, but DB2 does have a similar means of selecting from DML statements which could be used here (see data change table reference) (BEGIN is also a pg-ism). On the subject of performance I generally found DB2 to be happier with EXCEPT than NOT IN but ymmv. | |
| Jul 23, 2015 at 13:31 | comment | added | Tom | Thanks so much. I actually have a table with multiple other columns and the columns are all different than the example I gave - but the example described the problem easily and your solution should do the trick. Thanks again | |
| Jul 22, 2015 at 20:56 | history | edited | ypercubeᵀᴹ | CC BY-SA 3.0 | added 604 characters in body |
| Jul 22, 2015 at 20:46 | history | answered | ypercubeᵀᴹ | CC BY-SA 3.0 |