I am having a situation with the View treating the SQL statement below, when I run this statement, it orders all the records by date (oldest--newest), however when I make the View
with the same statement and run it, its ordering it rather by Product type name.
I am unable to figure this out.
I want it to show the results order by date.
Please can someone advise?
Thanks for any help.