go to post Dorian Tetu · Dec 6, 2023 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 TableWHERE Row=Name AND ID IN ( SELECT ID FROM Table WHERE Row=Surname)Instead of: SELECT ID FROM TableWHERE Row=NameINTERSECTSELECT ID FROM TableWHERE Row=SurnameHope that can help anyone with the same issue ^^ Certifications & Credly badges:Dorian has no Certifications & Credly badges yet.Global Masters badges:show all 4Followers:Dorian has no followers yet.Following:Dorian has not followed anybody yet.
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 ^^