I have two SQL 2000 table:
Table 1: UserID, Date
Table2: UserID, DateOut, DateIn
UserID is used as a join between both tables
table1.Date needs to be matched as a date that falls between table2.Dateout and table2.datein
I need a sql code to first find recods that match in table2 and a seperate code to show all records from table1 that do not have a match in table2.