select od1.order_id,od1.product_id,od1.quantity,od2.order_id
from Order_detail as od1 inner join Order_detail as od2
on od1.order_id <> od2.order_id
where od1.order_id=10248 and od1.product_id=72 and od1.quantity=5
数据库中表的自连接
最新推荐文章于 2024-04-28 13:06:51 发布