Your wt data is being duplicated as well, but you don't mention it. This is the way it's supposed to look based on the data you have and the type of query you're building. Look at it this way: in the first 5 rows, based on the fields selected and the record taken as a whole c&ce is repeating 5 times because there are that many combinations when all of the selected fields are taken into consideration. There are 2 records where the values of wt and allocation are the same, but their segment values are different. Put another way, if you want to see 5 values for a child field (segment) and ask to see the parent field as well (asset class) how can you expect the parent to show up only once?
You could try an equal join, but I don't foresee that helping. Try playing with the DISTINCT or DISTINCT ROW predicates (property sheet > Unique Values OR Unique Records; cannot have both). You may have to create some sort of Totals query in order to group by. I don't see the point in including the joined field on the many side. It's all the same values.
Special characters in your field names is not good practice (save for maybe the underscore). It's also odd to see the same value in two or more fields (c&ce)
Last edited by Micron; 05-26-2017 at 01:01 PM.
Reason: correction
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.