Oracle 21c

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

create table table1 (my_pk_col, samecol1, samecol2, samecol3) as
select 42, 1, 2, 3 from dual
1 rows affected

create table table2 (my_pk_col, samecol1, samecol2, samecol3) as
select 42, 1, 2, 3 from dual
1 rows affected

SELECT * FROM Table1
INNER JOIN Table2 ON Table1.MY_PK_COL = Table2.MY_PK_COL


MY_PK_COL
SAMECOL1
SAMECOL2
SAMECOL3
MY_PK_COL
SAMECOL1
SAMECOL2
SAMECOL3


42
1
2
3
42
1
2
3


SELECT * FROM Table1
JOIN Table2 USING (MY_PK_COL, SAMECOL1, SAMECOL2, SAMECOL3)


MY_PK_COL
SAMECOL1
SAMECOL2
SAMECOL3


42
1
2
3