Re: Column name in view

Put the column names into the VIEW declaration header, not the body of the view.

CREATE VIEW Foobar (id, name, study)
AS SELECT a.studend_id, a.student_name, b.course_study

     FROM view1 AS a, View2 AS b
    WHERE a.student_id = b.student_id; Received on Sat Nov 09 2002 - 18:07:04 CST