RE: Select between dates in another table.

SSC Guru

Points: 323504

November 12, 2013 at 8:10 am

the trick here is what some people call an "exotic" join, where it's not joining on discrete values, but rather on the criteria (between dates) you are looking for.

Something like this should give you the idea, and might even run without changes, based on your table/column names you posted here:

SELECT * FROM DutyRosterShift

INNER JOIN Vacation

ON DutyRosterShift.DATO BETWEEN Vacation.StartDate AND Vacation.EndDato

WHERE DutyRosterShift.ShiftType = 1

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!