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
<tbody>
</tbody>
etc etc
HOWEVER, in the third query, it generates values that DO NOT EXIST in the union table.
EG
<tbody>
</tbody>
Is this a bug, have I done something wrong? I have never seen this before.
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
Transaction 1 | a | Low |
Transaction 1 | a | Medium |
Transaction 2 | a | High |
Transaction 3 | b | High |
<tbody>
</tbody>
etc etc
HOWEVER, in the third query, it generates values that DO NOT EXIST in the union table.
EG
a | b | |
1 | Low | Medium |
2 | High | LOW (this value doesn't exist!) |
3 | LOW (doesn't exist!) | High |
<tbody>
</tbody>
Is this a bug, have I done something wrong? I have never seen this before.
Last edited: