mtagliaferri
Registered User.
- Local time
- Today, 10:21
- Joined
- Jul 16, 2006
- Messages
- 519
I have a staff members table with a related timeline table (one to many), this timeline table contains various records related to the staff member. I have a query that creates a list of staff members and the first records in the timeline table which is the Date Of Joining as follows:
This works perfectly, however I would like to have in the list also the Resigned record from the timeline table related to the staff member; would it be possible to select two records from the timeline table which contains the words "Date Of Joining" and "Resigned" from the "TimelineDescription" table, bearing in mind that "TimelineDescription" may contain other words as Resigned from...and it would need to pick this records because it contains the word resigned
Hope it makes sense
Code:
SELECT tblCrewMember.StaffNumber, tblCrewMember.Surname, tblCrewMember.Name, tblCrewMember.Position, tblCrewMember.Base, tblCrewMember.Nationality, tblCrewMemberTimeline.TimelineDate, tblCrewMember.Resigned, tblCrewMember.ResignedDate, tblCrewMember.DOB, tblCrewMember.Gender, tblCrewMember.CrewType, tblCrewMember.CallSign, tblCrewMember.MaidenName
FROM (qryCrewMemberTimelineFirstRecord INNER JOIN tblCrewMemberTimeline ON qryCrewMemberTimelineFirstRecord.MinOfIDTimelineCrewMember = tblCrewMemberTimeline.IDTimelineCrewMember) INNER JOIN tblCrewMember ON qryCrewMemberTimelineFirstRecord.IDCrewMember = tblCrewMember.IDCrewMember
ORDER BY tblCrewMember.StaffNumber;
Hope it makes sense