alias names of columns are lost when trying to edit a query in ms query..

• mudassar waseem

  Newbie

  Points: 1

  More actions

  February 16, 2006 at 2:22 pm

  #152771

  when trying to edit a query in ms query, the alias names of columns used in the query are lost.

   

  example query :

  select proj_name as 'project name', proj_nbr as 'project number' from proj

   

  when trying to save this query in ms query i get the following error

  "sql query can't be represented graphically. continue anyway?"

   

  Is there a way to fix this? If so how do i do that??

  Any help will be appreciated.

• Jo Pattyn

  SSC-Dedicated

  Points: 32518

  More actions

  February 16, 2006 at 2:33 pm

  #621484

  not sure if this works

  select proj_name as [project name], proj_nbr as [project number] from proj