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

icylin used Ask the Experts™
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.

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Engineer
Top Expert 2011

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.


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

Didnt get answer.
Paul JacksonSoftware Engineer
Top Expert 2011

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