create table l (
i integer primary key,
v varchar(20)
);
insert into l values (1, 'one' );
insert into l values (2, 'two' );
insert into l values (3, 'three');
insert into l values (4, 'four' );
insert into l values (5, 'five' );
select * from l
create table r (
i integer references l,
v varchar(20),
l char(2),
primary key (i,l)
);
insert into r values (2, 'zwei','de');
insert into r values (2, 'deux','fr');
insert into r values (2, 'dos' ,'es');
insert into r values (3, 'drei','de');
insert into r values (4, 'quattre','fr');
insert into r values (4, 'cuatro','es');
insert into r values (5, 'cinco','es');
select * from r
select * from l
--select * from r,l
--select * from r,l where r.i = l.i
--select * from r inner join l on r.i = l.i
--select * from r left outer join l on r.i = l.i
--select * from r right outer join l on r.i = l.i
--select * from r cross join l
i integer primary key,
v varchar(20)
);
insert into l values (1, 'one' );
insert into l values (2, 'two' );
insert into l values (3, 'three');
insert into l values (4, 'four' );
insert into l values (5, 'five' );
select * from l
create table r (
i integer references l,
v varchar(20),
l char(2),
primary key (i,l)
);
insert into r values (2, 'zwei','de');
insert into r values (2, 'deux','fr');
insert into r values (2, 'dos' ,'es');
insert into r values (3, 'drei','de');
insert into r values (4, 'quattre','fr');
insert into r values (4, 'cuatro','es');
insert into r values (5, 'cinco','es');
select * from r
select * from l
--select * from r,l
--select * from r,l where r.i = l.i
--select * from r inner join l on r.i = l.i
--select * from r left outer join l on r.i = l.i
--select * from r right outer join l on r.i = l.i
--select * from r cross join l