3 Replies Latest reply: Jul 23, 2012 11:23 AM by Miguel Angel Baeyens de Arce RSS

    Syntax error on where clause why ?

      
      


      Sprvsr:
      LOAD   EMPL_GROUP_DESC as [SprvsrName],
          EMPL_GROUP_CD as [SprvsrID];
         
      SQL SELECT *
      FROM [DELTEKTE].[TC_0012].[EMPL_GROUP];

      LEFT JOIN (Sprvsr)
      LOAD   EMPL_ID as [TE_Employee_ID],
          EMPL_GROUP_CD  as [SprvsrID];
         
      SQL SELECT *
      FROM [DELTEKTE].[TC_0012].[EMPL_GROUP_EMPL]
      WHERE MATCH (left[EMPL_GROUP_CD], 1)= 'M';