Name Student ID Name Student ID Registration ID Registered Subject
Jane 1324 Jane 1324 3213215 Y Math
Joe 1234 Jane 1324 3213215 N Math
Clare 6784 Joe 1234 54654646 Y English
James 8973 Joe 1234 54654646 N English
Any idea how'd I'd return subject from registration. There are more students in the student table but more entries on the registration table. I need all the students on the student table and only subject from registration where confirmed = 'Y' .
Thank you so much!