Post reply

joins

  • May 5, 2008 at 5:15 am

    #380311

    Hello,

    how many types of joins and briefly explain them.

    Regards,

    sathish.

  • May 5, 2008 at 5:41 am

    #810590

    [font="Verdana"]

    1] Inner Join: Returns the matching records from both the tables

    2] Outer Join

    2.1] Left Outer Join: Returns the matching records from both the tables + rest the records from Left side table

    2.2] Right Outer Join: Returns the matching records from both the tables + rest the records from Right side table

    2.3] Full Outer Join:

    3] Self Join: Means a table joined to itself. It returns the records from that table.

    4] Cross Join: Returns the Cartesian product.

    Mahesh

    [/font]

    MH-09-AM-8694

  • May 5, 2008 at 6:23 am

    #810622

    This is the kind of information you can get out of the Books Online as well as a gazillion third party books and web sites. Do a little basic research first and then if you get stuck, start posting the questions and people will help out. Fundamental stuff like this can't be adequately covered in small posts like above (as clear, concise, and accurate as it is).

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • May 5, 2008 at 7:52 am

    #810687

    Was this an interview question, or something on an exam? Are you looking for some specific data about joins, or just looking for someone to answer an interview question for you?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • March 10, 2010 at 5:32 am

    #1131278

    can you plz explain cross join

  • March 10, 2010 at 6:04 am

    #1131291

    [font="Verdana"]Refer BOL for more information

    Mahesh[/font]

    MH-09-AM-8694

  • March 11, 2010 at 5:24 am

    #1131943

    tabishghazi (3/10/2010)

    can you plz explain cross join

    Try this: CROSS JOIN

    Nigel
    How to post questions

  • May 23, 2010 at 7:47 am

    #1171289

    Nice explanation about the joins,

    I found this blog post [http://slackerdba.blogspot.com/] that gives good details about the basic joins with good examples.

    Hope that helps.

  • May 23, 2010 at 10:27 am

    #1171305

    This is one another nice simple-english visual-representative article on Baiscs of Joins from Pinal Dave; click on the link to follow it:

    sql-server-introduction-to-joins-basic-of-joins : Pinal Dave[/url]

    C'est Pras!!

  • June 2, 2011 at 9:13 am

    #1333163

    This site provides good explanations for SQL joins with lots of useful examples;

    http://www.codesnout.com

    http://www.codesnout.com/SQLSample/SQL-INNER-JOIN.php

  • June 3, 2011 at 5:25 pm

    #1333987

    Gsquare, excellent signature :hehe:

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths

  • June 7, 2011 at 12:38 am

    #1334803

    Cross join results cartesian product of two or more than two tables.

    Cross join matches each record from table1 to table2

    Eg. if table1 contains 5 records and table2 contains 4 records then our result is 20 records.

  • May 16, 2014 at 3:00 pm

    #1714357

    I am looking for some good video tutorials on joins.

    Found some good ones here

    http://sqlserver2012tutorial.com/

    http://blog.sqlauthority.com

    Could anybody suggest some more?

    Thanks

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply