| 26 Jun 2022 |
| ![@rcapile[d]:libera.chat](./avatar/rcapile%5Bd%5D) rcapile[d] joined the room. | 17:19:42 |
| ![@Stratus[d]:libera.chat](./avatar/Stratus%5Bd%5D) Stratus[d] left the room. | 17:37:25 |
| ![@thakidd[d]:libera.chat](./avatar/thakidd%5Bd%5D) thakidd[d] left the room. | 17:49:17 |
| ![@zPuls3[d]:libera.chat](./avatar/zPuls3%5Bd%5D) zPuls3[d] left the room. | 17:52:48 |
| ![@BobBloom[d]:libera.chat](./avatar/BobBloom%5Bd%5D) BobBloom[d] joined the room. | 17:56:44 |
| ![@illuminatide[d]:libera.chat](./avatar/%40illuminatide%5Bd%5D%3Alibera.chat) @illuminatide[d]:libera.chat left the room. | 18:17:09 |
| ![@tehjrow[d]:libera.chat](./avatar/tehjrow%5Bd%5D) tehjrow[d] joined the room. | 18:20:58 |
| ![@benconda[d]:libera.chat](./avatar/benconda%5Bd%5D) benconda[d] joined the room. | 18:44:38 |
| ![@lobotomised[d]:libera.chat](./avatar/lobotomised%5Bd%5D) lobotomised[d] joined the room. | 18:49:42 |
| ![@BlackScorp[d]:libera.chat](./avatar/%40BlackScorp%5Bd%5D%3Alibera.chat) @BlackScorp[d]:libera.chat left the room. | 18:57:10 |
| ![@adoy[d]:libera.chat](./avatar/adoy%5Bd%5D) adoy[d] joined the room. | 19:03:59 |
| thakidd[d] joined the room. | 19:05:41 |
| zPuls3[d] joined the room. | 19:15:28 |
| ![@ErfanGorgi[d]:libera.chat](./avatar/%40ErfanGorgi%5Bd%5D%3Alibera.chat) @ErfanGorgi[d]:libera.chat left the room. | 19:44:27 |
 Albright | Pretty sure I've solved this problem in the past but can't remember how. | 20:08:05 |
| ![@Victor[d]:libera.chat](./avatar/Victor%5Bd%5D) Victor[d] joined the room. | 20:09:11 |
| ![@ramsey[d]:libera.chat](./avatar/%40ramsey%5Bd%5D%3Alibera.chat) @ramsey[d]:libera.chat left the room. | 20:13:23 |
![@Crell[d]:libera.chat](./avatar/Crell%5Bd%5D) Crell[d] | Relational division is a fugly beast in sql. Avoid it if you can. | 20:17:46 |
| Crell[d] | I believe you need a sub query (or With clause) that does the join, then filter on that using a Where Not In. | 20:18:52 |
| Albright | Well, I finally found the right magic search engine words to return this: https://stackoverflow.com/a/6613895/11023 | 20:19:51 |
| ![@Rydian[d]:libera.chat](./avatar/%40Rydian%5Bd%5D%3Alibera.chat) @Rydian[d]:libera.chat left the room. | 20:32:34 |
| ![@Flypig07[d]:libera.chat](./avatar/%40Flypig07%5Bd%5D%3Alibera.chat) @Flypig07[d]:libera.chat left the room. | 20:42:24 |
| ![@ike[d]:libera.chat](./avatar/ike%5Bd%5D) ike[d] joined the room. | 20:43:00 |
| ![@chance[d]:libera.chat](./avatar/chance%5Bd%5D) chance[d] joined the room. | 20:45:00 |
| Albright | Yeah, the technique in that SO answer is working for my needs, and it looks familiar enough that I'm fairly sure it's the same approach I used before. | 20:47:34 |
| Albright | For context, I've got an X and several Ys, and Ys can be associated to X, but only once per Y. A I wanted to get a list of Ys which are not already associated with X for creating a "Associate New Y to X" menu. | 20:49:07 |
| Albright | *And I wanted | 20:49:21 |
| Stratus[d] joined the room. | 20:56:11 |
| ![@bruce[d]:libera.chat](./avatar/%40bruce%5Bd%5D%3Alibera.chat) @bruce[d]:libera.chat left the room. | 21:35:49 |
| ![@russ[d]:libera.chat](./avatar/%40russ%5Bd%5D%3Alibera.chat) @russ[d]:libera.chat left the room. | 22:34:21 |
