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 ^^