sql

From: Andreas Lommel <him_lommel_at_t-online.de>
Date: 2000/06/15
Message-ID: <39489233.94358109_at_news.btx.dtag.de>#1/1

Hi there, maybe someone can help me:
I have 2 tables
table1

name varchar2(10),      Smith, Scott, Robinson, Miller
salary number(5)           1000,1500,1300,1200
table2                           
name varchar2(10),      Meyer, Sinclair, 
age (2)                         34, 45

Now I want to create a third table which contains these 2 tables. table3
name varchar(10) Smith, Scott, Robinson, Miller,Meyer, Sinclair,

age(2)                           ,,,,34, 45
salary number(5)            1000,1500,1300,1200,,

How does it work ? Received on Thu Jun 15 2000 - 00:00:00 CEST