Tagged Questions
1
vote
2answers
685 views
LEFT JOIN conversion to INNER JOIN, can't change FROM clause
I have 2 tables:
BASE is master and is linked with CHILD via field ID: Left outer Join / 1:N relation.
These 2 tables contain historised data, defined by 2 date-fields: start_date and end_date.
...
