Before doing this I want to make sure it will work in a robust production application, so I'm posting this and hoping for some good advice.
Goal: To display a list of all possible activity participants and check only those participants who are active
My current approach is as follows:
- CREATE OR REPLACE VIEW selecting from list of active participants - (VW_ActivityParticipants).
- run a SELECT on the VIEW and a table of all possible participants (CrossRefTbl) with a LEFT JOIN between CrossRefTbl and VW_ActivityParticipants
- By doing this, it's possible for me to determine which participants need to be flagged as active.
Any feedback from all of you is appreciated, thanks much: Pavilion