Fixing AS keyword in Alias.
@@ -92,12 +92,12 @@ public class SQLConstants {
"TENANT_ID=?";
public static final String GET_CLAIMS = "SELECT CLAIMS.ID, PROPERTY.PROPERTY_NAME, PROPERTY.PROPERTY_VALUE, "
- + "CLAIMS.CLAIM_URI, RESOLVED.CLAIM_URI AS MAPPED_URI FROM IDN_CLAIM AS CLAIMS "
- + "LEFT JOIN IDN_CLAIM_PROPERTY AS PROPERTY "
+ + "CLAIMS.CLAIM_URI, RESOLVED.CLAIM_URI MAPPED_URI FROM IDN_CLAIM CLAIMS "
+ + "LEFT JOIN IDN_CLAIM_PROPERTY PROPERTY "
+ "ON PROPERTY.LOCAL_CLAIM_ID=CLAIMS.ID AND CLAIMS.TENANT_ID=PROPERTY.TENANT_ID "
- + "INNER JOIN IDN_CLAIM_MAPPING AS MAPPING "
+ + "INNER JOIN IDN_CLAIM_MAPPING MAPPING "
+ "ON MAPPING.EXT_CLAIM_ID=CLAIMS.ID AND CLAIMS.TENANT_ID=MAPPING.TENANT_ID "
- + "INNER JOIN IDN_CLAIM AS RESOLVED "
+ + "INNER JOIN IDN_CLAIM RESOLVED "
+ " ON RESOLVED.ID=MAPPING.MAPPED_LOCAL_CLAIM_ID AND RESOLVED.TENANT_ID=MAPPING.TENANT_ID "
+ "WHERE CLAIMS.DIALECT_ID=(SELECT ID FROM IDN_CLAIM_DIALECT WHERE DIALECT_URI=? AND "
+ "TENANT_ID=?) AND CLAIMS.TENANT_ID=?";
