Sorting Order query

[drunkenneo]

I have written a query where the date_processed column in the order_processed need to be sorted, and the data is populated from redemption_report:



INSERT INTO Orders_Processed ( contact_first_name, contact_last_name, bizid, bizname, order_number, order_date, Date_processed, reward_title, partner_name, quantity, email_address, contact_number, country_name, Uploaded_by ) SELECT contact_first_name,contact_last_name,bizid,bizname ,order_number, order_date , Uploaded_Date, reward_title, partner_name, quantity, email_address , contact_number, country_name, Uploaded_By FROM Redemption_Report ORDER BY Orders_Processed.[Date_processed] DESC

Please solve?

[offie]

How do you want it sorted? In the deisng view in the Sort row you can select ascending or descensing, and whichever one you want sorted first should be placed first (to the the left)