This is the join i get data out of 3 tables;

SELECT s.date, s.value, e.short_descr, r.name FROM sales s, entry_type e, retailer r WHERE s.fk_retailer_id=r.retailer_id AND s.fk_entrytype_id=e.id;

this query gives me a table of this kind:

+----------+---------------+-----------------+-----------+
| DATE     |    VALUE      |  SHORT_DESCR    |    NAME   |
+----------+---------------+-----------------+-----------+

is there a way to make the result of this query look like this: ? 

+----------+---------------+-----------------+---------------+
|  DATE    | SHORT_DESCR_A | SHORT_DESCR_B   | SHORT_DESC_C  |
+----------+---------------+-----------------+---------------+


Basically to make of each entry in SHORT_DESCR a Column with the corresponding values.

Sorry if it's not described cleary, not that easy ;)