What is the difference between equi join and natural join in sql?

icylin
icylin used Ask the Experts™
on
Hello,
Anyone please tell me what is the difference between equi- join and natural join in sql? It would be great if you could give me an example.

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Engineer
Top Expert 2011
Commented:
http://en.wikipedia.org/wiki/Join_(SQL)

An equi join is basically when you join based on a key - foreign key relationship in the where clause and is usually based only on one column

A natural join is where all columns that have the same name in both tables are compared. They are considered dangerous as as columns might have the same name but be unrelated e.g. a column called title or description may exist in both tables but be unreleated.

Author

Commented:
I've requested that this question be deleted for the following reason:

Didnt get answer.
Paul JacksonSoftware Engineer
Top Expert 2011

Commented:
I disagree that you didn't get an answer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial