SERVICE Table{id}
SITE Table{id,svcId(from SERVICE Table),siteid}

SELECT *
FROM SERVICE
WHERE EXISTS(
    SELECT * FROM SITE WHERE (siteid='3' or siteid='4') AND id IN (
    SELECT id FROM SITE GROUP BY id HAVING count(*) > 1
))