Re: create view

create view as

   select t1.name,

	t1.age,
	t1.date,
	t2.name,
	t2.age
    from table1 t1,
            table2 t2;

On Wed, 26 Jan 2000 12:54:13 GMT, him_lommel_at_t-online.de (Andreas Lommel) wrote:

>Hi there
>
>How can I create a view on 2 tables ?
>
>table1: name,age,date
>table2: name,age
Received on Wed Jan 26 2000 - 09:47:16 CST