SELECT *
FROM trnOrder o
INNER JOIN lnkOrder l
ON o.ID = l.OrderID
INNER JOIN tblOrganization org
ON o.OrgID = org.Code
where OrderDT = '2026-03-19 00:00:00.000' and ordertypeid = 1 order by 1 desc;
ID | MRMXOrderNo | OrgID | OrderDate | DeliveryDate | ModelID | Quantity | UoM | Code | JDECode | Name |
299145 | 1275350 | 65 | 20260318 | 20260318 | 10867 | 1 | 100PCS | 65 | 9700065 | MCDONALD'S MUAR |
299142 | 1275247 | 162 | 20260318 | 20260318 | 9505 | 1 | 144PCS | 162 | 9700162 | MCDONALD'S SECTION 3 SHAH ALAM |
299142 | 1275247 | 162 | 20260318 | 20260318 | 8269 | 1 | 126PCS | 162 | 9700162 | MCDONALD'S SECTION 3 SHAH ALAM |
299142 | 1275247 | 162 | 20260318 | 20260318 | 10961 | 1 | 9.9L | 162 | 9700162 | MCDONALD'S SECTION 3 SHAH ALAM |
299142 | 1275247 | 162 | 20260318 | 20260318 | 3021 | 1 | 60PCS | 162 | 9700162 | MCDONALD'S SECTION 3 SHAH ALAM |
299142 | 1275247 | 162 | 20260318 | 20260318 | 10867 | 2 | 100PCS | 162 | 9700162 | MCDONALD'S SECTION 3 SHAH ALAM |