0

Given this SQL statement written in ACCE:

SELECT 
 This, 
 D.ClassDescription,
 D.Id myId,
 D.MimeType myMimeType
FROM 
 Document D 
WHERE 
 D.Id= '{00093471-0100-C09E-828F-6B22177A2922}'

How do I properly alias the ClassDescription field?, it does not work like the other columns (properties).

I've tried using 'AS' and Brackets '[]' but no such luck, the column is silently removed from the results of the query.

Thank you, Stephen

Stephen Patten
  • 6,333
  • 10
  • 50
  • 84

1 Answers1

0

The aliasing of columns is straight-forward, you can use the following:

foo AS bar
foo [bar]
foo bar

As a side note to anyone who may peruse this question and answer, the installation of the ACCE instance I was using was somewhat problematic (or a bug), it would NOT allow me to alias the ClassDescription Property. If I programmatically create the same query using the SearchSQL API, the aliasing works as expected as long as it conforms to SQL-92 dialect.

Stephen Patten
  • 6,333
  • 10
  • 50
  • 84