Code: Select all
SELECT MESI.MM, MESI.MESE, Count(PRENOTAZIONI.IDTIP)
FROM PRENOTAZIONI RIGHT JOIN MESI ON PRENOTAZIONI.MM = MESI.M
WHERE PRENOTAZIONI.CANCL Is Null AND PRENOTAZIONI.AAAA="2022"
GROUP BY MESI.MM, MESI.MESE
Code: Select all
SELECT MESI.MM, MESI.MESE, Count(PRENOTAZIONI.IDTIP)
FROM PRENOTAZIONI RIGHT JOIN MESI ON PRENOTAZIONI.MM = MESI.M
WHERE PRENOTAZIONI.CANCL Is Null AND PRENOTAZIONI.AAAA="2022"
GROUP BY MESI.MM, MESI.MESE
TKS bro.HansV wrote: ↑22 Jul 2022, 10:56This is because your WHERE-condition requires records in PRENOTAZIONI to exist. Try this:
SELECT MESI.MM, MESI.MESE, Q.CONTA FROM MESI LEFT JOIN (SELECT MM, Count(IDTIP) AS CONTA FROM PRENOTAZIONI WHERE CANCL Is Null AND AAAA="2022" GROUP BY MM) AS Q ON MESI.MM = Q.MM ORDER BY MESI.MM
Oh yes, that makes so much more sense.yes but you can use also M
OPS...
Sorry...