Re: Column name in view
From: Tibor Karaszi <tibor_not_pressed_ham_.karaszi_at_cornerstone.se>
Date: Sat, 09 Nov 2002 16:26:14 GMT
Message-ID: <GGaz9.3865$1r1.125912_at_newsc.telia.net>
Date: Sat, 09 Nov 2002 16:26:14 GMT
Message-ID: <GGaz9.3865$1r1.125912_at_newsc.telia.net>
That seems like a bug in your DBMS. The column names in the resultset from your query should (IMO) be: "ID", "Name" and "Study".
What DBMS are you using?
-- Tibor Karaszi "K.Y. Fung" <kyfung_at_hotmail.com> wrote in message news:c22bb40d.0211090647.7ff57277_at_posting.google.com...Received on Sat Nov 09 2002 - 17:26:14 CET
> Hi everybody,
>
> Suppose I have created 2 views:
>
> view1 consists of 2 columns: student_id, student_name.
> view2 consists of 2 columns: student_id, course_study.
>
> The following query will result in a table of 3 columns with the
> following headings: "view1 view2 ID", "view1 view2 Name", "view1 view2
> Study"
>
> 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
>
> how can I remove the "view1 view2" from the headings?
>
> Regards,
> K.Y. Fung