The one I asked before
SELECT t1.journal_id FROM journal AS T1 JOIN journal_committee AS T2 ON T1.journal_ID   =   T2.journal_ID WHERE T2.work_type   =   'Photo'
The requirement is to select journal IDs from a journal table that have a work type of 'Photo' in a related journal_committee table; joining of tables is required to match journal IDs between the two tables.