Timeline for Oracle: finding rows without children in a table with a foreign key?
Current License: CC BY-SA 4.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 5, 2018 at 19:21 | history | edited | MDCCL | CC BY-SA 4.0 |
Tag created recently.
|
| Apr 6, 2015 at 9:53 | answer | added | David Aldridge | timeline score: 4 | |
| Apr 3, 2015 at 9:04 | history | reopened |
Hannah Vernon♦ Vérace Paul White♦ Colin 't Hart Michael Green |
||
| Apr 2, 2015 at 18:08 | comment | added | ypercubeᵀᴹ |
select a.* from a where x not in (select x from b); or: select a.* from a where not exists (select 1 from b where b.x = a.x);
|
|
| Apr 2, 2015 at 17:46 | review | Reopen votes | |||
| Apr 3, 2015 at 9:04 | |||||
| Apr 2, 2015 at 17:31 | comment | added | Mark Harrison | yes, and I'll try to rephase the question as well. | |
| Apr 2, 2015 at 17:30 | history | edited | Mark Harrison | CC BY-SA 3.0 |
rewrote from scratch to make the question clear
|
| Apr 2, 2015 at 17:16 | vote | accept | Mark Harrison | ||
| Apr 2, 2015 at 15:58 | history | closed |
Colin 't Hart RolandoMySQLDBA Vérace Shanky Hannah Vernon♦ |
Needs details or clarity | |
| Apr 2, 2015 at 13:22 | answer | added | kevinskio | timeline score: 3 | |
| Apr 2, 2015 at 9:06 | review | Close votes | |||
| Apr 2, 2015 at 15:58 | |||||
| Apr 2, 2015 at 8:50 | comment | added | Colin 't Hart | Can you give us your example? | |
| Apr 2, 2015 at 7:39 | history | asked | Mark Harrison | CC BY-SA 3.0 |