10 Replies Latest reply on Aug 17, 2012 7:29 AM by disabled_mr_vodka

    SQL and Null

    kaostika

      I have a SQL join on a 4 fields

       

      SELECT DISTINCT a."ID"

      FROM "Disciplines" a

      INNER JOIN "Wdiscipline" b ON a."Discipline" = b."Discipline"

      AND a."FeaturedCourseID1" = b."FeaturedCourseID1"

      AND a."FeaturedCourseID2" = b."FeaturedCourseID2"

      AND a."FeaturedCourseID3" = b."FeaturedCourseID3"

       

      This works well except if there is a Null result in one of the fields. The id's does not register. How can I get Null fields to be ignored or still work here. For instance if Discipline is null it will not show up in the list of ID's

       

      Oreste