drop table Bierladen1;
drop table Bierladen2;
drop table IntegratedBierladen;

create table Bierladen1(
Personal_ID number constraint pk_stud_id1 primary key,
Name varchar(10),
Fachrichtung varchar(10),
Abschluss varchar(10)
);

insert into Bierladen1 values (1,'Mark','Verkaeufer','Lehrling');
insert into Bierladen1 values (2,'Pete','Lagerist','Geselle');

create table Bierladen2(
Personal_ID number constraint pk_stud_id2 primary key,
Name varchar(10),
Verkaeufer varchar(10),
Lagerist varchar(10)
);

insert into Bierladen2 values (1,'Mark','Lehrling',NULL);
insert into Bierladen2 values (2,'Pete',NULL,'Geselle');


create table IntegratedBierladen(
Personal_ID number constraint pk_stud_id primary key,
Name varchar(10),
Geselle varchar(10),
Lehrling varchar(10)
);

select * from Bierladen1;
select * from Bierladen2;
select * from IntegratedBierladen;