Hi, i know that's an old post but still,
I also needed to use an INTERSECT statement and I managed to replace it with "IN"

example:
SELECT ID FROM Table
WHERE Row=Name AND ID IN (
           SELECT ID FROM Table
           WHERE Row=Surname)

Instead of:

SELECT ID FROM Table
WHERE Row=Name
INTERSECT
SELECT ID FROM Table
WHERE Row=Surname

Hope that can help anyone with the same issue ^^