Hi,
I am trying to play around with query but got stuck in fixing the bug.
Please see attachment. I am trying to link the color code from a table to another table which stores the definition of color code. However, it gives me duplicate results.
In Excel, this could be achieved by using...