Hi All,
I would like to achieve the following:
Customer Date Metric Figure Metric Figure
1 26-Apr 5 … 11 …
2 26-Apr 5 … 11 …
3 26-Apr 5 … 11 …
4 26-Apr 5 … 11 …
5 26-Apr 5 … 11 …
The 4 first Columns are easy:
SELECT Customer, Date, Metric, MetricFigure
FROM TBL_Customers
WHERE Date '26-APR-2016' AND MetricFigure = '5'
Then I would like to do the same query wth MetricFigure = '11' and display the values in a column adjacent to the first query.
What is the best solution to do this?
Many Thanks!