Timeline for Return only rows under certain constraints in join
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 17, 2020 at 17:07 | vote | accept | jewnbug97 | ||
| Apr 15, 2020 at 15:58 | answer | added | Laurenz Albe | timeline score: 2 | |
| Apr 15, 2020 at 15:57 | comment | added | jewnbug97 |
@LaurenzAlbe yes, it is just a custom business requirement. There can be multiple status's for child rows present against a parent but as soon as a status exists with at_home, I don't want any parent rows to be returned
|
|
| Apr 15, 2020 at 15:47 | comment | added | Laurenz Albe | There are two child rows for parent 1 where status <> 'at_home', so why shouldn't it be returned? Perhaps you could clarify your condition. | |
| Apr 15, 2020 at 15:22 | history | asked | jewnbug97 | CC BY-SA 4.0 |