Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement