|Subject||Is it possible to have a SELECT with a variable number of columns?|
I have an application where the tables are all normalized and so the taxes are not in the same table as the sales.
Sometimes a sale should to pay 1 tax, sometimes 2 taxes, sometimes 3 taxes, etc.
And it would be nice to have in just 1 row data of the sale and of the taxes, each tax in its own column:
DATE, INVOICE, AMOUNT, TAX1, TAX2, TAX3, ... TAXN