Some databases have the concept of a natural join. It joins two tables on common columns. Not quite what I would want. I would prefer something like a key join

Some databases have the concept of a natural join. It joins two tables on common columns. Not quite what I would want. I would prefer something like a key join that uses foreign key relationships. I don't know if any database has that though. (If anybody does, please let me know.) Oracle: https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljnaturaljoin.html https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljnaturalj... MySQL: https://dev.mysql.com/doc/refman/8.4/en/join.html https://dev.mysql.com/doc/refman/8.4/en/join.html