Re: create view

From: Gary Waldrom <garyw_at_amonra-insight.com>
Date: Wed, 26 Jan 2000 16:21:41 -0000
Message-ID: <E47927FC0A9CD3119D090000216DAFF5034506@THOTH>

A view just overlays a query, assuming that the name is the PK-FK relationship

CREATE OR REPLACE VIEW viewname AS
SELECT t1.name, t2.age, t1.date FROM table1 t1, table2 t2 WHERE t1.name = t2.name

you can then select * from viewname and return the data from the underlying query

Gary Waldrom
Amonra Insight Ltd.
Authors of Q-file IT Quick Reference Guides http://www.q-file.com

-----Original Message-----
From: him_lommel_at_t-online.de (Andreas Lommel) [mailto:him_lommel_at_t-online.de]
Posted At: Wednesday, January 26, 2000 12:54 PM Posted To: server
Conversation: create view
Subject: create view

Hi there

How can I create a view on 2 tables ?

table1: name,age,date
table2: name,age Received on Wed Jan 26 2000 - 10:21:41 CST