getting error which says to create unique aliases for duplicate fields

[jonathan184]

Hi I am trying to get my query to work in my middleware which piggybacks off of the mssql driver using jdbc.
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.

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

[Rabbit]

You have two fields in your result set with the same name. You need to use an alias.

SELECT someField AS someField1, someField AS someField2
FROM someTable

[jonathan184]

Thanks your help was greatly appreciated. It works fine now.