Inner join logical operator returns those records from more than one tables which have the exact value in the column which is being used in joining condition.
Preferably the join is based on referential integrity enforcing the relationship between the tables to ensure data integrity.
Example:-
If we have duplicate records then inner join behaves like cross join for those duplicate records.
Example:-
No comments:
Post a Comment