Here is a query to return the Parts that use/involve Spec 2 OR 3.
Code:
SELECT PartsT.PartName
, PartSpecT.SpecID
FROM PartsT INNER JOIN PartSpecT
ON PartsT.PartsID = PartSpecT.PartID
WHERE ((PartSpecT.SpecID)in(2,3));
This one identifies Parts that use SPEC 2 And SPEC 3
Code:
SELECT PartsT.PartsID
, PartsT.PartName
, PartSpecT.SpecID
, PartSpecT_1.SpecID
FROM (PartsT INNER JOIN PartSpecT ON
PartsT.PartsID = PartSpecT.PartID)
INNER JOIN PartSpecT AS PartSpecT_1 ON
PartsT.PartsID = PartSpecT_1.PartID
WHERE (((PartSpecT.SpecID)=2) AND ((PartSpecT_1.SpecID)=3));