I have a mysql table named Sales from where I need to get all the combinations of MONTH and YEAR in order to put them in a list, look at this example:
This can be the table Sales:
I want to populate a combobox that could bring the list in pair Month-Year based on DATE_SALE field, something like this:
As you can see there are only the month-year involved in all registers of Sales table.
Thanks in advance.