Advanced (?) SQL help

[winch]

Perhaps,

select name from photos where id in (select photo_id from photo_tags where tag_id in (6, 13);

[tszanon]

Perhaps,

select name from photos where id in (select photo_id from photo_tags where tag_id in (6, 13);

The nested SELECT will return all photos that have the tags 6 or 13, not those that have both tags.
At the moment, I don't see any other alternative to do what the original post wants.

Good luck!

[olejorgen]

Yeah, I guess I'll just use it. It seems kinda strange that it's not a better way. I'd assume this kind of problem pops up fairly often

[winch]

The nested SELECT will return all photos that have the tags 6 or 13, not those that have both tags.

Opps.

You could also do this,

select name from photos where id in(select photo_id from (select photo_id, count(*) as count from photo_tags where tag_id in (6, 13) group by photo_id) where count = 2);

That will work as long as the photo_tags table doesn't have duplicate rows.