Re: Column name in view

"Tibor Karaszi" <tibor_not_pressed_ham_.karaszi_at_cornerstone.se> wrote in message news:<v7qz9.3251$h%5.119291_at_newsb.telia.net>...
> "--CELKO--" <71062.1056_at_compuserve.com> wrote in message
> news:c0d87ec0.0211091607.2d38b63f_at_posting.google.com...

> Another possibility is that K.Y. is using some query tool which tries to
> "help" by using some meta-data and exposes "where the data comes from" with
> the column names.

CELKO solution works, and for your reference the SQL I used, I think, is a study verions package. It is called InfoMaker SQL Anywhere which is using the SQL:1989 specification.

By the way through some trial and error I found another way that works, it was by putting a () to enclose the column name as follows:

SELECT (a.studend_id) AS "ID", (a.student_name) AS "Name", (b.course_study) AS "Study"
FROM view1 a, view2 b
WHERE a.student_id = b.student_id

May be different SQL implementation has different syntax to do the same thing. In this case may be SQL Anywhere treats () as a special function that "un-help" by "hiding where the data comes from" and remove the "view1 view2" from the heading.

???

Regards,
King Yin Fung Received on Mon Nov 11 2002 - 03:12:51 CET