MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tblPhotos (`photoID` INTEGER, `photoName` VARCHAR(1));

INSERT INTO tblPhotos (`photoID`, `photoName`) VALUES
  ('1', 'w'),
  ('2', 'x'),
  ('3', 'y'),
  ('4', 'z');
CREATE TABLE tblPhotoTags  (`photoID` INTEGER, `tagID` INTEGER);

INSERT INTO tblPhotoTags (`photoID`, `tagID`) VALUES
  ('1', '1'),
  ('1', '2'),
  ('2', '1'),
  ('3', '2'),
  ('4', '1'),
  ('4', '2');
SELECT DISTINCT photoID
FROM tblPhotoTags
WHERE tagID IN (1, 2);


photoID


1

2

3

4


SELECT photoID
FROM tblPhotoTags
WHERE tagID IN (1, 2)
GROUP BY photoID
HAVING COUNT(*) = 2 -- the number of tagIDs in the IN list


photoID


1

4


SELECT DISTINCT p.*
FROM tblPhotos p INNER JOIN tblPhotoTags t
ON t.photoID = p.photoID
WHERE t.tagID IN (1, 2);


photoID
photoName


1
w

2
x

3
y

4
z


SELECT p.photoID, p.photoName
FROM tblPhotos p INNER JOIN tblPhotoTags t
ON t.photoID = p.photoID
WHERE t.tagID IN (1, 2)
GROUP BY p.photoID, p.photoName
HAVING COUNT(*) = 2 -- the number of tagIDs in the IN list


photoID
photoName


1
w

4
z