I am building a query.
I am looking at one table. There are 3 columns I am looking at. They are Top_LVL_IDENT and LOWER_LVL_IDENT and LOC.
I have multiple top levels, which can come across this line (or LOC, if you will), and will consume the LOWER_LVL_IDENTS. The LOWER_LVL_IDENTS can go into multiple TOP_LVL_IDENTS, but not all of them... For instance
TOP LVL IDENTS could be A B and C. Three different parts.
LOWER LVL IDENTS could be 1 2 3 4 5 and 6
TOP LVL IDENT B will use 1 2 3 4 5 and 6.
TOP LVL IDENT C will use 1 3 4 5 and 6
TOP LVL IDENT A will use only 1 4 and 5
Because 2 is only unique to TOP LVL IDENT B, in this location, I only need to have this record.
Any thoughts? I am sure it is simple, but my brain was fried getting as far as I did, and I can not see the solution. Thank you, in advance!