asked
How to select in a n-n ids structure with multiple AND?
I have a table: id1 | id2 1 1 1 2 2 1 2 3 3 1 3 2 3 3 I need to select all id1 where id2=value AND id2=value2 I loose myself trying it, any hint?
Not an expert in mysql but try select id1 from YourTable where id2 = value and id1 in ( select id1 from YourTable where id2 = value2)
9 People are following this question.
