我有微不足道的问题与我的mysql查询。我想只显示与6
顺序状态不同的行。但是id_order
有多个雕像,意思是:
id_order = 8421
**has two statuses:**
id_order_state=8 and
id_order_state = 6.
下面是我的表的例子:link
I tried with:
SELECT * FROM order_history WHERE id_order_state != 6 (but here I need more code that I can't handle)
谢谢你的帮助
编辑:orders 8421, 8422不应该显示在result
尝试:
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
试试这个
> SELECT * FROM order_history WHERE id_order_state <> 6
或
> SELECT * FROM order_history WHERE id_order_state NOT IN ( 6)
就像这样?
SELECT *
FROM order_history
WHERE id_order NOT IN
(SELECT id_order FROM order_history WHERE id_order_state = 6);