Column name in view
From: K.Y. Fung <kyfung_at_hotmail.com>
Date: 9 Nov 2002 06:47:44 -0800
Message-ID: <c22bb40d.0211090647.7ff57277_at_posting.google.com>
Hi everybody,
Date: 9 Nov 2002 06:47:44 -0800
Message-ID: <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 - 15:47:44 CET
