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>
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)
FROM view1 AS a, View2 AS b
AS SELECT a.studend_id, a.student_name, b.course_study