'sqlite3 selecting all 1:n values from an n:n table
I have an sqlite table that relates 2 entities, in the form
x | y
1 1
1 3
2 2
2 3
3 1
3 2
3 3
Expected output: 3 (because x=3 links to y=1,2,3, aka all values of y)
I need to select all values in x that have a relation to every value in y My issue is that when I group by x, then check how many y-values there are for a given group of x's, I don't know how many y values there are total because I just grouped my table by x's and can't access the original one to count.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
