Question
· Mar 12, 2020

Intersect in Cache Database

Hi,

        What is the alternative for INTERSECT in cache. I tried Intersect but not working.

Thanks for suggestions.

 

 

 

thanks

 

Jude

Discussion (3)3
Log in or sign up to continue

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