Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT if(if(eo.shipment_date > 0,eo.shipment_date,0) && if(date(o.pickup_date) > 0,date(o.pickup_date),0) && if(eo.shipment_date > 0,eo.shipment_date,0) != if(date(o.pickup_date) > 0,date(o.pickup_date),0), 1, 0),
- eo.shipment_date, o.pickup_date
- FROM external_order AS eo
- LEFT JOIN `order` AS o ON o.id = eo.erp_order_id
Add Comment
Please, Sign In to add comment