Mysql查询不显示不相等值的行

Question

我的 mysql 查询有一个小问题。我想仅显示顺序状态与 6 不同的行。但是id_order有多个雕像，这意味着例如:

id_order = 8421
**has two statuses:**
id_order_state=8 and
id_order_state = 6.

这是我的表格的示例:link

我尝试过:

SELECT * FROM order_history WHERE id_order_state != 6 (but here I need more code that I can't handle)

感谢您的帮助

编辑:订单 8421、8422 不应显示在结果中

Answer 1

尝试:

SELECT i.* FROM order_history i
left join order_history e 
       on i.id_order = e.id_order and e.id_order_state = 6
WHERE  e.id_order_hitory is null