[snip]
CREATE TABLE order_cross
SELECT date_format(data_iniz_num,'%y') as anno,ord_tmp.soc,ord_tmp.ml,
ord_tmp.cod_agente, ord_tmp.linea,
CASE WHEN month(data_ordine) = 1 then qty else 0 END as jan,
CASE WHEN month(data_ordine) = 2 then qty else 0 END as feb,
CASE W
Dear Dirs,
I think I' ve found a bug.
Please run the following query
(I know you don' t have my db,
try something similar)
CREATE TABLE order_cross
SELECT date_format(data_iniz_num,'%y') as anno,ord_tmp.soc,ord_tmp.ml,
ord_tmp.cod_agente, ord_tmp.linea,
CASE WHEN
Dear Dirs,
I think I' ve found a bug.
Please run the following query
(I know you don' t have my db,
try something similar)
CREATE TABLE order_cross
SELECT date_format(data_iniz_num,'%y') as anno,ord_tmp.soc,ord_tmp.ml,
ord_tmp.cod_agente, ord_tmp.linea,
CASE WHEN
