Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- student_id | name | member_type
- 10 | Ali | Not A Member
- 14 | James | Member of Taekwando
- 15 | Bakar | Not A Member
- committee_id | email | image |
- 1 | abc@gmail.com | pic.jpg |
- 2 | abccd@ymail.com | pic1.jpg |
- 3 | shdhs@yahoo.com | pic2.jpg |
- event_id | event_name | start_date | committee_id |
- 11 | Sport Meeting | 2018-12-19 20:00:00 | 1 |
- 12 | Yamacha Tonite | 2018-12-18 21:00:44 | 1 |
- 13 | Family Gathering | 2018-12-17 22:00:44 | 3 |
- evt_id | event_id | student_id | status_info |
- 111 | 11 | 10 | Not Going |
- 112 | 12 | 14 | Going |
- 113 | 13 | 15 | Going |
- Sport Meeting | 2018-12-19 20:00:00 | 10 | Not A Member | Not Going
- Yamacha Tonite| 2018-12-18 21:00:44 | 14 | Member of Taekwando | Going
- select
- e.event_name,
- e.start_date,
- es.student_id,
- s.member_type,
- es.status_info
- from evtstatus es
- join student s on s.student_id = es.student_id
- join event e on e.event_id = es.event_id
- join committee c on c.committee_id = e.committee_id
- where e.committee_id = 1
Add Comment
Please, Sign In to add comment