<--- --------------------------------------------------------------------------------------- ----
Blog Entry:
Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions
Author:
Ben Nadel / Kinky Solutions
Link:
http://www.bennadel.com/index.cfm?dax=blog:1572.view
Date Posted:
Apr 23, 2009 at 10:00 AM
---- --------------------------------------------------------------------------------------- --->
SELECT
g.id,
g.name
FROM
girl g
INNER JOIN
(
SELECT
gtjn.girl_id
FROM
girl_trait_jn gtjn
WHERE
gtjn.trait_id IN ( )
GROUP BY
gtjn.girl_id
HAVING
COUNT( * ) =
) AS filter
ON
g.id = filter.girl_id
ORDER BY
g.name ASC
SELECT
id,
name
FROM
trait
ORDER BY
name ASC
Select Records My ID Set Matching