Hai All

when i executae the following query i am getting an error saying that

Sting truncation,numeric overflow .can any body tell me why i will get
this error in this situation. there is no null values in the columns.


SELECT
a.commodityid
FROM
jccommodity a
LEFT JOIN test b on (a.commodityid=b.commodityid)
GROUP BY
a.commodityid

test in the above query is the view the definition is

CREATE VIEW test
as
SELECT commodityid from jcspec
GROUP BY
commodityid

Thankx
Usha