Skip to content
Advertisement

Tag: inner-join

Getting all weeks data of a month using inner join

I have the following query: Above query explanation: I’m getting all weeks data PaidKM which driver gets in a whole month. The month for example starting date is 01-07-2018 and ending date is 31-07-2018 which covers whole month # 07. But when I change the month it gives me the same results all time. Above GIF’s query implementation: I have

Advertisement