SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table Movie(shared1 int, unshared2 text);
✓
insert into Movie values(1, 'a');
✓
insert into Movie values(2, 'b');
✓
create table Rating(shared1 int, unshared3 int);
✓
insert into Rating values(1,3);
✓
insert into Rating values(1,3);
✓
select * from Movie natural join Rating;


shared1
unshared2
unshared3


1
a
3

1
a
3


select * from Movie inner join Rating;


shared1
unshared2
shared1
unshared3


1
a
1
3

1
a
1
3

2
b
1
3

2
b
1
3


select * from Movie cross join Rating;


shared1
unshared2
shared1
unshared3


1
a
1
3

1
a
1
3

2
b
1
3

2
b
1
3


select * from Movie inner join Rating on Movie.shared1 = Rating.shared1;


shared1
unshared2
shared1
unshared3


1
a
1
3

1
a
1
3