Column name in view

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 - 08:47:44 CST