I have two tables linked by serial number. The YEAR_IMPORTED has a list of dosimeters with serial numbers and readings for the whole year. The DOSL_ALLOCATION table has a list of the dosimeter serial number along with the person it was issued to for which quarter. So a dosimeter can be issued to one person in the 2nd quarter and a different person in the 4th quarter.
When I run the query below I expected only the dosimeter readings for the 4th quarter to show up, but I'm getting the reading for both the 2nd and 4th quarters.
How can I get only the dosimeters for the 4th quarter?
Thank you.
you.