This should be easy, but I've been fudging with this for a while so
someone can help.
I have 2 tables: fruit, fruitchoices.
The first (fruit) is a read-only lookup table:
The second (fruitchoices) table stores the user's selections:
I need a query that will produce the entire list of fruit along with a
user's choices. For example:
fid, fruit, uid
1, apple, 1
2, banana, null
3, orange, 1
4, peach, null
5, pear, null
Where 'null' is returned for ...