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...
> 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
Received on Sat Nov 09 2002 - 10:26:14 CST
