This content has been marked as final. Show 2 replies
I have a problem with filtering out unwanted data. I have two different tables with "timestamps" (dates and times), table1 and table2.
I need to check if table table2 have direct preceeding or direct following timestamps of table1.
If not then display those items in a third table otherwise ignore them.
I have tried making a "unique key" out of the fields id + date from/to + time from/to and use it in a NOT EXISTS() function.
But I can not seem to get it to work right.
Any help is appreciated.
See attached file.