Finding unmatched/missed dates within same table

  • Thread starter Thread starter Alp Bekisoglu
  • Start date Start date
A

Alp Bekisoglu

Hi Experts,

Can't seem to come up with the logic. I have a 'meetings' table with two
date fields, one for the meeting date (meet_date) the other for the next
meeting (meet_next_date) carrying the same meet_co_id and meet_contact_id.

I would like to see if a scheduled meeting (meet_next_date) is missed
looking for initial 'meet_id' > 'meet_id' but the meet_date <> or >
meet_next_date of the previous meeting (or maybe even no further meetings).

Makes any sense? If not let me know what is needed for help.

Thanks in advance.

Alp
P.S.: As an example I'd like to catch an entry like below:
meet_id meet_date meet_next_date meet_co_id meet_contact_id
1 20/02/2006 25/02/2006 5 3
8 27/02/2006 a date or none 5 3
 
Solved via 3 queries! One with meet_date as ddate, one with meet_next_date
as ddate and yet another one to include ones where dates don't match using
the previous two as source.

Alp
 
Back
Top