I need to create a SELECT statement against two tables:
Table 1: Languages
Table 2: Narrators_Languages
I need to return all records in the Languages table, and specify a Narrator_ID from the Narrators_Languages table. For each record, return 'YES' if there is a record for the specified Narrator_ID else return 'NO'.
Languages 'EN', 'FR', 'SP'
Narrators_Languages: Narrator_ID = 2 and Language_ID = 'EN', Narrator_ID = 2 and Language_ID = 'SP'
(no record for Narrator_ID = 2 and Language_ID = 'FR')
Narrator_ID Language_ID Match
2 'EN' YES
2 'SP' YES
2 'FR' NO
Thanks for any help with this!