SELECT
rd_m.cCode,
rd_m.dDate,
rd_m.dDate,
rd_d.cInvCode,
rd_d.cBatch,
rd_d.iQuantity

FROM [dbo].[RdRecord01] rd_m

LEFT JOIN rdrecords01 rd_d
ON rd_m.ID = rd_d.ID

WHERE dDate < '2021-11-01'