Unexplainable SQL Result
I know! SQL can be strange and throw up peculiar results at times, but this is really simple SQL with an allegedly simple result. What I have is 3 tables. Table 1: One column, which is a list of dates covering every day between 31.12.2019 and 31.12.2023.Table 2: Two columns: Column 1 is the date of an event and column 2 is the count of the number of times the event occurred on the date in col...