User bio
404 bio not found
Member since Oct 4, 2023
Posts:
Dorian has not published any posts yet.
Replies:
show all 1
Dorian Tetu · Dec 6, 2023 go to post

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

Certifications & Credly badges:
Dorian has no Certifications & Credly badges yet.
Followers:
Dorian has no followers yet.
Following:
Dorian has not followed anybody yet.