I'm trying to create a View across 3 tables. Let's say I'm having a dinner party and I have the tables
a. Guests
b. Food Items
c. Exclusions (this is a list of Guest / Food Combinations that are not valid - e.g., guest is allergic to this item).
I'm trying to create a view that has every combination of Guests and Foods, and includes Exclusions if it exists and matches the combination of guest and food.
Would love to get some help with this - have been wrestling with every combination of inner and outer join I can think of and I'm not getting there.
It seems like this shouldn't be that hard, but I either get only rows with C or I get a single exclusion matching to a bunch of records it shouldn't.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
DaveS
I'm trying to create a View across 3 tables. Let's say I'm having a dinner party and I have the tables
a. Guests
b. Food Items
c. Exclusions (this is a list of Guest / Food Combinations that are not valid - e.g., guest is allergic to this item).
I'm trying to create a view that has every combination of Guests and Foods, and includes Exclusions if it exists and matches the combination of guest and food.
Would love to get some help with this - have been wrestling with every combination of inner and outer join I can think of and I'm not getting there.
It seems like this shouldn't be that hard, but I either get only rows with C or I get a single exclusion matching to a bunch of records it shouldn't.
Thanks in advance
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.