mysql - 我的sql语句语法错误，请帮忙!

Question

我不确定我在这里做错了什么，但我有一个语法错误

SELECT * `Orders` o
LEFT JOIN Shipment s 
ON  o.for_shipment_id  = s.shipment_id
WHERE 'internal_status' = 'HAS_SHIP_INFO' 
AND (s.ship_method = 'FEDEX' OR s.ship_method = 'USPS' OR s.ship_method = 'UPS')

Answer 1

您在 * 之后缺少 FROM。

SELECT * 
  FROM   <-- You're missing this :o)
`Orders` oLEFT JOIN Shipment s ON  o.for_shipment_id  = s.shipment_idWHERE 'internal_status' = 'HAS_SHIP_INFO' AND (s.ship_method = 'FEDEX' OR s.ship_method = 'USPS' OR s.ship_method = 'UPS')