Hi All,
I have a table which gets joining and leaving dates for crew, it is something like this:
SeatimeID, CrewID, JoinDate, LeaveDate
The CrewID is linked to a crew table and so therefore the data in the seatime table looks something like this :
1, 120, 1/1/23, 2/1/23
2, 12, 12/1/23...