Hi All,
Another half day of thinking and testing provided me with some type of usable result 🙂
I ended up writing different select statements with different WHERE conditions and joining them to a select that used a case statement to manage preferences.
when preference1.data is null then preference2.data else preference1.data etc
I can see lots of reads on this post, and I dont blame anyone for not being able to slog through my question. Thank you to all who gave it a whirl 🙂
- Damien