I have a custom date dimension table, I need to create a left join so that when I have a date with no orders the date is still output.
My current custom date dimension scrip is:
Select Distinct x.[Common Date], WEEKOFYEAR(x.[Common Date]) as [Week Number] from (
Select [ORDER_DATE] AS [Common Date]
Select [REPORTEDREGDATE] AS [Common Date]
) as x
How do I insert a left join as I am unable to add a customer field to the table?
Please sign in to leave a comment.