Hello,Thanks for any help in advance.BRIEF VERSION OF QUESTION:I have 2 Views that pull Employment data: Employment_App_VIEW (EA), and Employ_Jobs_VIEW (EJ). The problem lies in the operator in the second WHERE Clause (EA.Application_Date <> 'NULL'). When I try to change the <> operator to the = operator to get the opposite results, no results show up. This is what I came up with for the first query (that works):SELECT *FROM Employment_App_VIEW EA INNER JOIN Employ_Jobs_VIEW EJ ON EA.App_ID = EJ.App_IDWHERE (EJ.Creation_Date LIKE '03%') AND (EA.Application_Date <> 'NULL')ORDER BY EA.Application_Date DESC]
So I ofcourse thought that all I'd have to do to pull users with "<NULL>" values in their "Application_Date" column was to do this query:SELECT *FROM Employment_App_VIEW EA INNER JOIN Employ_Jobs_VIEW EJ ON EA.App_ID = EJ.App_IDWHERE (EJ.Creation_Date LIKE '03%') AND (EA.Application_Date = 'NULL')ORDER BY EA.Application_Date DESC]
...but the "AND (EA.Application_Date = 'NULL')" line doesn't seem to work. Shouldn't the = operator work in the opposite way of the <> operator? And since the <> operator query works, why wouldn't the query that uses the = operator instead?DETAILED VERSION OF QUESTION:I'm working on creating a job that will pulls users from 2 Views I created that have added one or more jobs to their application today using the "Application Date" column from Employment_App_VIEW (EA), and another report of who has actually submitted their application today using the "Creation_Date" column from Employ_Jobs_VIEW (EJ). (See queries above for problem)KWilliams
NEWBIE: SQL Query/VBScript Question
Posted - 2004-03-16 : 11:29:55
