https://community.qlik.com/t5/Talend-Studio/SQl-Query-Retreiving-Data-from-globalmap-get-quot-quot-function/m-p/2300495#M72720 SYNTAX is my prob, but im not sure where. My capitolization is correct. <BR />java.sql.ResultSet rs_tMSSqlInput_2 = stmt_tMSSqlInput_2.executeQuery("SELECT dbo.BASE_MODULE_NUMS.MATNR,dbo.BASE_MODULE_NUMS.MAKTX FROM dbo.BASE_MODULE_NUMS where dbo.BASE_MODULE_NUMS.MATNR ="((String)globalMap.get("row2.MATNR"))"); <BR />Thanks Sat, 16 Nov 2024 13:57:30 GMT Anonymous 2024-11-16T13:57:30Z https://community.qlik.com/t5/Talend-Studio/SQl-Query-Retreiving-Data-from-globalmap-get-quot-quot-function/m-p/2300495#M72720 SYNTAX is my prob, but im not sure where. My capitolization is correct. <BR />java.sql.ResultSet rs_tMSSqlInput_2 = stmt_tMSSqlInput_2.executeQuery("SELECT dbo.BASE_MODULE_NUMS.MATNR,dbo.BASE_MODULE_NUMS.MAKTX FROM dbo.BASE_MODULE_NUMS where dbo.BASE_MODULE_NUMS.MATNR ="((String)globalMap.get("row2.MATNR"))"); <BR />Thanks Sat, 16 Nov 2024 13:57:30 GMT https://community.qlik.com/t5/Talend-Studio/SQl-Query-Retreiving-Data-from-globalmap-get-quot-quot-function/m-p/2300495#M72720 Anonymous 2024-11-16T13:57:30Z https://community.qlik.com/t5/Talend-Studio/SQl-Query-Retreiving-Data-from-globalmap-get-quot-quot-function/m-p/2300496#M72721 you need to concatenate strings in Java. <BR /> <PRE>where dbo.BASE_MODULE_NUMS.MATNR = " + (String)globalMap.get("row2.MATNR"));</PRE> <BR />Talend also supports Perl which is a bit more "user friendly" when it comes to string handling. Thu, 14 May 2009 06:09:52 GMT https://community.qlik.com/t5/Talend-Studio/SQl-Query-Retreiving-Data-from-globalmap-get-quot-quot-function/m-p/2300496#M72721 Anonymous 2009-05-14T06:09:52Z