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 |