在 PSEUDO CODE中:
SELECt * FROM IMAGES INNER JOIN IMAGETAGS A ON IMAGE.ID = A.IMAGEID AND A.TAGID = 'A' INNER JOIN IMAGETAGS B ON IMAGE.ID = B.IMAGEID AND B.TAGID = 'B' INNER JOIN IMAGETAGS C ON IMAGE.ID = C.IMAGEID AND C.TAGID = 'C'
只是猜测,但是JPQL中的等效项是
Select img from Image img JOIN img.tag ta JOIN img.tag tb JOIN img.tag tc WHERe ta.description = 'A' and tb.description = 'B' and tc.description = 'C'



