Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT sh.*,c.`City` FROM `oe_shipment` sh
- JOIN `os_city` c on c.`ID`=sh.`idCity`
- WHERE sh.`idCity`=7 AND sh.`udate` BETWEEN STR_TO_DATE('2017-06-01 00:00:00', '%Y-%m-%d %H:%i:%s')
- AND STR_TO_DATE('2017-06-22 23:59:59', '%Y-%m-%d %H:%i:%s') ORDER BY sh.`ID` DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
