SQL query not working (cancelled/approved orders)

by programming_amazing   Last Updated May 15, 2019 20:09 PM

I've been trying without success to obtain all the orders that were approved (not all lines must be approved to be considered an approved order) and orders that were COMPLETELY cancelled given the approver email.

Once the order is placed in MAGENTO, all the information is stored in 2 tables (ORDER_INFO_TABLE and APPROVE_TABLE).

Take a look at this image:

ca

ca2

I've been trying different queries but no one really helped me :(

I want to obtain ALL THE ORDERS that were APPROVED & COMPLETELY CANCELLED for a specific approver.

Tags : magento-1.9


Related Questions


Updated September 01, 2016 08:05 AM

Updated May 21, 2017 16:09 PM

Updated May 24, 2015 02:04 AM

Updated July 21, 2017 21:09 PM

Updated May 16, 2018 16:09 PM