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

Posted by Udaysimha under Sql Server on 1/17/2012 | Points: 10 | Views : 7223 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

0	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

Latest Posts