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 stef@...

[Non-text portions of this message have been removed]