cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Difference between inner join and reference join.

Former Member
0 Likes
20,970

Hi,

Please can some one explain the difference between inner join and reference join.

Thanks,

Shakthi.

View Entire Topic
Former Member
0 Likes

REFERENCE JOIN is used to enable referential integrity and contraints from base tables and will facilitate a simpler SELECT INNER JOIN statement as it is not necessary or required to expose base tables columns.  There is more to it, hope this will get you started.