Anyway, The query gets this error when i run in it the middleware
ERROR: Failed to create input and/or output schema(s): "Duplicate field name found 'NAME', please modify the query and create unique aliases for duplicate fields""
The query otherwise runs fine in the microsoft SQL client in the studio
This is the query I am trying to run.
Could someone help me on how to create unique aliases for duplicate fields or if you could modify the query so i could see how you did it or give an example. This would be helpful.
Expand|Select|Wrap|Line Numbers
- SELECT DISTINCT (RNP_DOCUMENT_TYPES.NAME),
- RNP_FIELDS.NAME,
- RNP_DOCUMENT_TYPE_FIELDS.IS_KEYWORD_FLAG,
- RNP_DOCUMENT_TYPE_FIELDS.IS_ONBASE_KEYWORD_FLAG,
- RNP_DOCUMENT_TYPE_FIELDS.IS_REQUIRED_FLAG,
- RNP_DOCUMENT_TYPE_FIELDS.SEQUENCE,
- RNP_DOCUMENT_TYPE_FIELDS.IS_IMAGE_FLAG
- FROM
- RNP_DOCUMENT_TYPE_FIELDS,
- RNP_DOCUMENT_TYPES,
- RNP_FIELDS
- WHERE
- RNP_DOCUMENT_TYPES.DOCUMENT_TYPE_ID=RNP_DOCUMENT_TYPE_FIELDS.DOCUMENT_TYPE_ID and
- RNP_DOCUMENT_TYPE_FIELDS.FIELD_ID=RNP_FIELDS.FIELD_ID
- and RNP_DOCUMENT_TYPES.NAME='BOL'
- ORDER BY
- RNP_DOCUMENT_TYPE_FIELDS.SEQUENCE ASC