Question: what is difference between referential join and inner join?
Answer: A inner join gives data only when it exists in both left and right table. An inner join is always executed. A referential join is also an inner join but it assumes that the referential integrity is maintained.