Hi, If any of you is in to writing SQL for a component, please note that following style of sub query is not supported by MSSQL server.
example: INSERT INTO USER_ROLE (USER_ID, ROLE_ID, TENANT_ID) *VALUES(* (SELECT ID FROM USER WHERE USER_NAME=? AND TENANT_ID=?), (SELECT ID FROM ROLE WHERE ROLE_NAME=? AND TENANT_ID=?), ?) On MSSQL this will result in an error with a message similar to "*Subqueries are not allowed in this context. Only scalar expressions are allowed*.". The query should be modified to match following syntax. INSERT INTO USER_ROLE (ROLE_ID, USER_ID, TENANT_ID) *SELECT* (SELECT ID FROM ROLE WHERE ROLE_NAME=? AND TENANT_ID=?), (SELECT ID FROM USER WHERE USER_NAME=? AND TENANT_ID=?), (?) /sumedha
_______________________________________________ Carbon-dev mailing list Carbon-dev@wso2.org https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
