JohnMac328
asked on
CF - Display multiple null fields
I am trying to show checked out videos for each employee by listing who has a Checked out date (not null) and a In date that is not null times two. There are a maximum of 2 videos checked out per person. The sql shows who has videos out but I want it to show when a person has two null checked in when they have two not null checked out fields. The end of my SQL statement is pseudo code to show where I am trying to specify two checked out for an employee. Any help is appreciated
SELECT Employees.First_Name, Employees.Last_Name, VideoList.Video_Name, Detail.In_Date, Detail.Out_Date
FROM Employees INNER JOIN
Detail ON Employees.EmployeeID = Detail.EmployeeID INNER JOIN
VideoList ON Detail.VideoID = VideoList.VideoID
WHERE (Detail.In_Date IS NULL) times two and Detail_out is not null times two
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome :)
ASKER