mysql - How to select photos that are in selected albums -
i couldn't figure out how word question, i'm going use typical example. imagine have common design photo albums 3 tables - photos, albums, photo_albums (a lookup table). albums names a, b , c. how find photos in both , c? if table design , want filter on album name. can this: select * photos exists ( select null photo_albums join albums on photo_albums.albumid=albums.albumid photos.photoid=photo_albums.photoid , albums.albumname in ('a','b') ) i think better solution via id if have one. this: select * photos exists ( select null photo_albums photos.photoid=photo_albums.photoid , photo_albums.albumid in (1,3) )