Database error: Invalid SQL: Select a.orders_id, a.payment_method, a.orders_no, a.date_purchased, a.currency_value, a.orders_status,a.customers_name, a.customers_email_address ,a.customers_telephone ,a.customers_street_address,a.freight_cost, b.products_quantity , c.products_name, d.orders_tracking_id,d.account_info,d.bank_name,d.date,d.price as tracking_price , e.freight_caption ,e.basic ,f.payway_code,f.flag as payway_flag, a.Total,a.afterDiscount from orders as a left join orders_products as b on a.orders_id=b.orders_id left join products_description as c on b.products_id=c.products_id and c.language_id='1' left join orders_tracking as d on d.orders_id=a.orders_id left join freight_area as e on e.freight_id=a.freight_id left join payway as f on f.payway_id = a.payment_method where a.store_id = 1 order by a.orders_id DESC
MySQL Error: 1054 (Unknown column 'a.Total' in 'field list')