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 ;)