What is the differecne between equi-join and inner-join and natural join.

Advertise your Business Here

Refer this Site

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

What is the differecne between equi-join and inner-join and 
natural join..Is there any difference or all are same?

Question Submitted By :: Prashanthi

I also faced this Question!!

Rank

Answer Posted By

Re: What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

Answer
# 1

All are same.

Eg:

SELECT
	*
FROM  Emp INNER JOIN Emp1
ON eid=id


SELECT
	*
FROM  Emp EQUI JOIN Emp1
ON eid=id

SELECT
	*
FROM  Emp NATURAL JOIN Emp1
ON eid=id

Is This Answer Correct ?

5 Yes

24 No

Mobin Sathupally

Re: What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

Answer
# 2

INNER JOIN and EQUI-JOIN are same. Not sure about Natural 
Join. Found answer in Books On Line.

Is This Answer Correct ?

9 Yes

13 No

Monal

Question	Asked @	Answers
Other SQL Server Interview Questions


How m-m relationships are implemented?		1
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha		4
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??		1
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?	Marlabs	8
In which year relase the 7.0& 2000 & 2005?		1
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.	IBM	4
What are the different ways of moving data/databases between servers and databases in SQL Server?	HCL	2
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?		5
Questions on identity?	Infosys	1
What is difference between Triggers and store procedure?		2
how to find nth highest salary	NexGen	30
Plz tell about backup&recovery?		2
Can anybody explain me cold backup and hot backup?	TCS	3
What is a materialized view?		2
How do you fine the performance tunning?	Accenture	2
what is physical sort data and logical sort data in index?		2
What is an execution plan? When would you use it? How would you view the execution plan?		1
How can i change the column name.	HCL	7
What are the differences between stored procedure and functions in SQL Server 2000?	TCS	12
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz		6

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com