数据库中表的自连接

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