kaostika

SQL and Null

Discussion created by kaostika on Jul 30, 2012
Latest reply on Aug 17, 2012 by disabled_mr_vodka

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

Outcomes