Topic: Comparing of records in one table on one column
Good afternoon, faced the task. A condition.
There is a table with records and the creation date, each record refers to the intermediate table... I understand difficult, an example:
ID, DOCTYPE, NAME, DOCDATE
And the intermediate table with the link to record, a type:
DOCTYPE, ID, BASEID, where baseid the link to the document.
Documents of different types, question are stored in the table... And how to select records where date of referring documents it is admissible it is equal?
1 (PR, 1, Bla-bla, 2/20/2018), (2, TR, Bla-bla, 2/21/2018)
Intermediate (PR, 1, 2)