I need to join 3 tables to get payment method of specific order id
Let me explain my query.
I have to load a custom_id and take saved order id from my table 'custom_data'. Now I want to find which payment method is used for this order id.
join-tablemagento-1.9payment-methodssales-order
I need to join 3 tables to get payment method of specific order id
Let me explain my query.
I have to load a custom_id and take saved order id from my table 'custom_data'. Now I want to find which payment method is used for this order id.
Best Answer
// id you are getting from your custom table on which you have to load order_id.
result: Array ( [id] => 1 [order_id] => 100000001 [payment_method] => checkmo ).