Hi Pedro,

previous i send the screen shot but it not visable , plz can i send the your mail

Hi Pedro,

I send the mail

Hi Pedro,

OK. I resolve  value too long issue.


((Select from table2.value from table2 where table2.id= table.id AND (table2.attibute_id =31) LIMIT 1),1,59)

((Select from table2.value from table2 where table2.id= table.id AND (table2.attibute_id =31) LIMIT 1),1,30)

(Select from table2.value from table2 where table2.id= table.id AND (table2.attibute_id =34) LIMIT 1)

  please give this solutions also how to use in talend
first  i know this condition table2.id= table.id (i am using innerr join)
second   Select from table2.value from table2 ?(how to use????????????)
third  table2.id= table.id AND (table2.attibute_id =34) LIMIT 1( how to use ???????????????)

Last edited by indira (2012-07-06 09:08:44)

Hi Pedro,

yes correct, This is full sql query this query is  already i am using java,but how to use talend

SELECT SUBSTRING((SELECT ccev.value FROM catalog_category_entity_varchar AS ccev WHERE ccev.entity_id = cce.entity_id AND (ccev.attribute_id = 31) LIMIT 1 ),1,59) AS NAME, SUBSTRING((SELECT ccev.value FROM catalog_category_entity_varchar AS ccev WHERE ccev.entity_id = cce.entity_id AND (ccev.attribute_id = 31) LIMIT 1 ),1,30) AS VALUE, (SELECT ccev.value FROM catalog_category_entity_text AS ccev WHERE ccev.entity_id = cce.entity_id AND (ccev.attribute_id = 34) LIMIT 1 ) AS description FROM catalog_category_entity AS cce