Good day everybody,
I have the following query
____________________________________________________________________________
____________________
select
D.NAME as NAME,
(case (extract (Weekday from P.plandate )) when 1 then (P.PLANSTATUS)
else '' end) as Monday,
(case (extract (Weekday from P.plandate )) when 2 then (P.PLANSTATUS)
else '' end) as Tuesday,
(case (extract (Weekday from P.plandate )) when 3 then (P.PLANSTATUS)
else '' end) as Wednesday,
(case (extract (Weekday from P.plandate )) when 4 then (P.PLANSTATUS)
else '' end) as Thursday,
(case (extract (Weekday from P.plandate )) when 5 then (P.PLANSTATUS)
else '' end) as Friday,
(case (extract (Weekday from P.plandate )) when 6 then (P.PLANSTATUS)
else '' end) as Saturday,
(case (extract (weekday from P.plandate )) when 0 then (P.PLANSTATUS)
else '' end) as Sunday
from driverplan P
join DRIVERS D on P.DRIVERNR = D.DRIVERNR
where P.plandate >= '2017/01/01'
order by 1
____________________________________________________________________________
____________________
My question is why does it not return 1 row per driver, but instead I get 7
rows?
Else how can I achieve this?
Regards
Stef van der Merwe
Email [email protected]
[Non-text portions of this message have been removed]
