[Solved] Ascending or descending list...

[Nick N,]

Hello,

I'd like to submit to your attention 2 subsequent queries.
I tried this:

Code: Select all

SELECT "Products"."brand", "Story"."date of purchase", YEAR( "date of purchase" ) AS "years", MONTH( "date of purchase" ) AS "months" FROM "Story", "Products" WHERE "Story"."ID_product" = "Products"."ID_product" ORDER BY "years", "months" ASC

Can anyone show me an alternative way to obtain an ascending list?

Thanks

Nick

[robleyd]

Did you try ORDER BY"date of purchase"? Assuming that is a date field.

[UnklDonald418]

to cover multiple items with the same purchase date

Code: Select all

ORDER BY "Story"."date of purchase", "Products"."brand" ASC

or maybe

Code: Select all

ORDER BY "Story"."date of purchase",  "Products"."unit price" ASC

or list most expensive items first

Code: Select all

ORDER BY "Story"."date of purchase" ASC,  "Products"."unit price" DESC

Using non-printing characters in field names can come back to bite you. If you don't like run on names like "dateofpurchase" use "date_of_purchase" or "date-of-purchase". When writing queries, abbreviated names are easier to type like "upr" and "dop".

[Nick N,]

Thank you for having replied quickly.
Regards
Nick