如何选择相册中的照片?

I couldn't figure out how to word this question, so I'm going to use a typical example. Imagine I have a common design for photo albums with 3 tables - photos, albums, photo_albums (a lookup table). Albums names are A, B and C.I couldn't figure out how to word this question