Hello SQL expert,
I am trying to make the color fields as values in one parameter called "Color" but not sure
what is the best way to update my basic query
FROM EMPLOYEE_TBL A
JOIN COLOR_TBL B
ON A.EMLOYEE_ID = B.EMPLOYEE_ID
And here is the result set when I run above query:
So, I want to create a parameter called "Color" with all these values (RED, YELLOW, BLUE, BLACK, or WHITE) so I can run the report with either RED, YELLOW, BLUE, BLACK, or WHITE condition.
Anyone how do I update my query?