I have a enrolment table which show what segment and year candidates enrolled.
I need to create a report show a candidate enrol for segment A and/or enrol segment B.
I have insert the same table 2 times and link to each other, left outer join. So it suppose whover sit for segment A will show up no matter they sit segment B or not.
The problems is enrolment table is including all different segments. I need to filter out just show segment B. Once I applied this filter, it would only show candidates sit for A and B. Candidate sit for segment A, not sit segment B is not showing.