A referential join gives the same results as which other join type?

A referential join specifically operates on the concept of a primary key and a foreign key relationship between two tables, ensuring that the join only includes rows where there is a match between the two tables. This type of join guarantees that only the rows from both tables that have corresponding matches are returned.

An inner join functions similarly, as it also includes only those rows from both tables where there is a match on the specified join condition. It filters the data such that only the intersecting data points between the two tables are retrieved, leading to a result set that includes only the rows where a relationship exists, just like a referential join.

In context, while other types of joins like left outer join can include unmatched rows from one table, or spatial joins focus on geographic data, the characteristics of the referential join align most closely with those of an inner join, which enforces similar constraints and leads to equivalent results when the data relationships are enforced correctly.