Three Level Query (select> union> crosstab) generating unrequested values!

[oliviar]

Hi Guys,
I've tried looking for this, but I am totally stumped!
I have a select query with criteria in it, joining many tables together (generating a value of low, medium, high for my transactions), then I created a union table stacking columns A and B values together.
All is fine in the union table, it generates the values I expect.
Eg
[TABLE="width: 400"]
<tbody>[TR]
[TD]Transaction 1[/TD]
[TD]a[/TD]
[TD]Low[/TD]
[/TR]
[TR]
[TD]Transaction 1[/TD]
[TD]a[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]Transaction 2[/TD]
[TD]a[/TD]
[TD]High[/TD]
[/TR]
[TR]
[TD]Transaction 3[/TD]
[TD]b[/TD]
[TD]High[/TD]
[/TR]
</tbody>[/TABLE]

etc etc

HOWEVER, in the third query, it generates values that DO NOT EXIST in the union table.

EG

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]a[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Low[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]High[/TD]
[TD]LOW (this value doesn't exist!)[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]LOW (doesn't exist!)[/TD]
[TD]High[/TD]
[/TR]
</tbody>[/TABLE]


Is this a bug, have I done something wrong? I have never seen this before.