Query and unmatched records

[jlgray0127]

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!

[aytee111]

I'm not sure I understand what you are trying to achieve. In your above example, you could do a count of lower lvl and if the count is 1 then keep that record, ignoring the top lvl. You could then query off those records to get the rest of the information you require.