SELECT
rd32_m.cCode,
rd32_m.dnverifytime,
rd32_d.AutoID,
rd32_d.cInvCode,
rd32_d.cFree1,
rd32_d.iQuantity,
rd32_d.cPosition,
rd32_d.cBatch,

rd10_d.cInvCode,
rd10_d.cFree1,
rd10_d.iQuantity,
rd10_d.cPosition,
rd10_d.cBatch

FROM rdrecords32 rd32_d

LEFT JOIN rdrecord32 rd32_m
ON rd32_d.ID = rd32_m.ID

LEFT JOIN [dbo].[rdrecords10] rd10_d
ON rd10_d.isodid=rd32_d.iorderdid

LEFT JOIN AA_BatchProperty batch
ON rd32_d.cInvCode = batch.cInvCode
AND rd32_d.cBatch = batch.cBatch

WHERE batch.cBatchPropertyGUID IS NULL

ORDER BY rd32_m.dnverifytime