SELECT ','+A.Message from(SELECT CONVERT(INT,Substring(MessageID,16,LEN(MessageID)-15)) AS GRP_ID,Message,LanguageCode
          FROM MESSAGES
          WHERE MessageGroup ='Screen'
          and MessageID LIKE 'PERMISSION_%'
          and CONVERT(INT,Substring(MessageID,16,LEN(MessageID)-15)) in (1,2,3)
          AND LanguageCode = 1033) as A
          INNER join PERMISSION_GROUP B
          on A.GRP_ID=B.GRP_ID INNER JOIN EMPLOYEE_GROUP C
			ON B.GRP_ID=C.GRP_ID AND B.LANG_LCLE_ID = 1033
          WHERE
           C.EMP_ID='A1PATEL' 
           FOR XML PATH('')
          

EMPLOYEE_GROUP
EMP_ID   GRP_ID     STR_ID
AAA        1          900
AAA        2          900
AAB        1          900
BBB        1          900  

PERMISSION_GROUP
GRP_ID    GRP_DESCR      LANG_LCLE_ID
1         Cashier         1033
1         Cashier         3084
2         Supervisor      1033
2         Supervisor      3084

MESSAGES
MessageGroup      LanguageCode   MessageID    Message
Menu                1033          KEYF2        E_ESC
Screen              1033          test         E_test

         on A.GRP_ID=B.GRP_ID INNER JOIN EMPLOYEE_GROUP C
			ON B.GRP_ID=C.GRP_ID AND B.LANG_LCLE_ID = 1033

      on A.GRP_ID=B.GRP_ID INNER JOIN EMPLOYEE_GROUP C
			ON B.GRP_ID=C.GRP_ID AND B.LANG_LCLE_ID
        WHERE
           C.EMP_ID='A1PATEL' 
AND B.LANG_LCLE_ID = 1033
           FOR XML PATH('')

quote:

---

Originally posted by jimf

You just combined two statements. Change

         on A.GRP_ID=B.GRP_ID INNER JOIN EMPLOYEE_GROUP C
			ON B.GRP_ID=C.GRP_ID AND B.LANG_LCLE_ID = 1033

to

      on A.GRP_ID=B.GRP_ID INNER JOIN EMPLOYEE_GROUP C
			ON B.GRP_ID=C.GRP_ID AND B.LANG_LCLE_ID
        WHERE
           C.EMP_ID='A1PATEL' 
AND B.LANG_LCLE_ID = 1033
           FOR XML PATH('')

Everyday I learn something that somebody else already knew

---