[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 WHEN month(data_ordine) = 3 then qty else 0 END as mar,
CASE WHEN month(data_ordine) = 4 then qty else 0 END as apr,
CASE WHEN month(data_ordine) = 5 then qty else 0 END as may,
CASE WHEN month(data_ordine) = 6 then qty else 0 END as jun,
CASE WHEN month(data_ordine) = 7 then qty else 0 END as jul,
CASE WHEN month(data_ordine) = 8 then qty else 0 END as aug,
CASE WHEN month(data_ordine) = 9 then qty else 0 END as sep,
CASE WHEN month(data_ordine) = 10 then qty else 0 END as oct,
CASE WHEN month(data_ordine) = 11 then qty else 0 END as nov,
CASE WHEN month(data_ordine) = 12 then qty else 0 END as 'dec'
FROM ord_tmp;
ERROR GIVEN : ERROR 1105 at line xx : Unknown error
[/snip]
Is it an error that each of your month listings have no single quotes around
them, but dec does? Just checking - unable to test at the moment.
HTH!
Jay
sql, mysql, query
"Football incorporates the two worst elements of American society: violence
punctuated by committee meetings." -George Will
*************************************
* Want to meet other PHP developers *
* in your area? Check out: *
* http://php.meetup.com/ *
* No developer is an island ... *
*************************************
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
