this post was submitted on 01 Jul 2024
35 points (94.9% liked)
LinkedinLunatics
5873 readers
4 users here now
A place to post ridiculous posts from linkedIn.com
(Full transparency.. a mod for this sub happens to work there.. but that doesn't influence his moderation or laughter at a lot of posts.)
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
That structure doesn't handle polyamorous and cheating relationships very well. It should probably have
and (select top 1 1 from dbo.relationships r where r.partner_a != GIRLS.id or r.partner_b != GIRLS.id)which would handle also LGBT+ relationships or relationships that are better represented as a graph.