Home Forums Article Discussions Article Discussions by Author Discuss content posted by bitbucket Intersecting - 1 RE: Intersecting - 1

  • February 26, 2014 at 8:14 am

    #1692305

    Equivalent to:

    SELECT X AS 'Intersecting'

    FROM A

    JOIN b ON b.y = a.x;

    It's not equivalent, INTERSECT returns DISTINCT values.

    SELECT DISTINCT X AS 'Intersecting'

    FROM A

    JOIN b ON b.y = a.x;