Date:2013/05/30
Category: EC-CUBE
Category: EC-CUBE
mtb_pref2.name as "order_pref",
mtb_pref.name as "deliv_pref",
FROM dtb_order
JOIN mtb_pref ON (dtb_shipping.shipping_pref = mtb_pref.id)
JOIN mtb_pref AS mtb_pref2 ON (dtb_order.order_pref = mtb_pref2.id)
としてあげればOKです。