SQL query recursion for a web-like structure
- by MickeyD
I have a table here, named "Foo". The data is set up something like this.
ID TableReference DataId0 DataId1 DataId2
-- -------------- ------- ------- -------
1 Prize 3 4 5
2 Prize 4 5 NULL
3 Cash 1 NULL …
