Is natural join is there in sql server? [Resolved]

Posted by Udaysimha under Sql Server on 1/17/2012 | Points: 10 | Views : 4876 | Status : [Member] | Replies : 5
Hi All,
Is natural join is available in sql sesrver and what are all the joins in sql server? please let me know all about joins in sql server.
Thanks

uday


Responses

Posted by: Raj_chennai on: 1/17/2012 [Member] Starter | Points: 50

Up
0
Down

Resolved
Inner Join
Outer Join
Left Outer Join
Right Outer Join
Full Outer Join
Cross Join
Natural join does not exist in sql server2005


raj

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Raj_chennai on: 1/17/2012 [Member] Starter | Points: 25

Up
0
Down
There is no Natural Join in SQL Server

raj

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Udaysimha on: 1/17/2012 [Member] Starter | Points: 25

Up
0
Down
thanks for your reply for my post. What about self join and non equi join boss.

uday

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/14/2012 [Member] Bronze | Points: 25

Up
0
Down

Natural join is not available in sql sesrver

non-equi-join
Joins that do not test for equality are non-equi-joins.

self-join
A self-join is simply a normal SQL join that joins one table to itself

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/14/2012 [Member] Silver | Points: 25

Up
0
Down
There in no natuaral joins in SQL
Joins in SQL
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response