Difference between natural join and equi join?

Interview Candidate
Sep 12th, 2006
1
12625

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

Som

Oct 5th, 2006

natural join is basically a form of equi join where one of the join fields is projected out. i.e. it avoids repeatition of the join column. ex:
select pub.id,pub.name,au.*
from publisher pub, author au
where pub.id = au.id --- this query depicts a natural join
select *
from publisher pub, author au
where pub.id = au.id --- this query depicts an equi join