Re: Column name in view

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 9 Nov 2002 16:07:04 -0800
Message-ID: <c0d87ec0.0211091607.2d38b63f_at_posting.google.com>


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 Sun Nov 10 2002 - 01:07:04 CET

Original text of this message