Consider two tables: ANALITIC and INTRAT.

In ANALITIC I have REGISTRATION_DATE as date of registration and REGISTRATION_NUMBER as number of registration. The same REGISTRATION_NUMBER could be linked to different REGISTRATION_DATE (eg. the REGISTRATION_NUMBER 2 may be linked to REGISTRATION_DATE 01/02/2023 and 03/04/2023, format DD/MM/YYYY). I have to consider the registrations linked to a certain REGISTRATION_CODE.

For each one of these REGISTRATION of 2023 (01/01/2023 – 31/12/2023) I have to find, if present, a link to INTRAT_BILL available on table INTRAT. On the table INTRAT for the same REGISTRATION_DATE and REGISTRATION_NUMBER I can have one INTRAT_BILL, more than one INTRAT_BILL, or no one INTRAT_BILL. From table INTRAT I have to obtain the INTRAT_VALUE linked to INTRAT_BILL.

Tried a LEFT JOIN between ANALITIC and INTRAT based on REGISTRATION_DATE but received results regarding older dates.

SELECT
    a.REGISTRATION_NUMBER
    a.REGISTRATION_DATE
    a.REGISTRATION_CODE
    i.INTRAT_BILL
    i.INTRAT_VALUE
FROM
    ANALITIC a
LEFT JOIN
    INTRAT i
ON
    a.REGISTRATION_DATE = i.REGISTRATION_DATE
WHERE
    a.REGISTRATION_DATE BETWEEN 20230101 and 20231231 AND
    a.REGISTRATION_CODE = '222222'
ORDER BY
    a.REGISTRATION_DATE, a.REGISTRATION_NUMBER;