Counting and joining two tables
- by Eikern
Eventhosts – containing the three regular hosts and an "other" field (if someone is replacing them)
eventid | host (SET[Steve,Tim,Brian,other])
-------------------------------------------
1 | Steve
2 | Tim
3 | Brian
4 | other
5 | other
Event
id | other | name etc.
----------------------
1 | | …
2 | |…