Rename Columns in MS Query
From: Lasse <lars.matsson_at_era.ericsson.se>
Date: 14 Nov 2003 01:33:05 -0800
Message-ID: <a6a79447.0311140133.51deede1_at_posting.google.com>
Hi!
Date: 14 Nov 2003 01:33:05 -0800
Message-ID: <a6a79447.0311140133.51deede1_at_posting.google.com>
Hi!
[Quoted] I have problem to rename columns in MS Query.
I use MS Query (Ver. 2000) to get data from an Oracle Server (Ver. 8.1.7...).
In Oracle the script is: Select columnname as "name"... and in MS Query I guess it's: Select Columnname as ‘name'... but it does work.
I have tried to double click in the Columnname and set a name in Column heading: , but I get an error message when I run the query. (ORA-00923: From keyword not found where expected) but the SQL code is: Select Columnname AS 'name'....
Please, can somebody help me!
Regards Lasse Received on Fri Nov 14 2003 - 10:33:05 CET