Pages

Sunday, 7 October 2012

Venn diagram (Visual Representation) of SQL joins.


We all knows SQL joins are used to fetch data from different tables but if for fresher its very easy to understand types of JOINS by visually rather than queries. So today i am going to write article based on that so user can get idea easily.

Ø  LEFT OUTER JOIN: produces a complete set of records from Table A, with the matching records (where available) in Table B. If there is no match, the right side will contain null.
Ø  RIGHT OUTER JOIN: produces a complete set of records from Table B, with the matching records (where available) in Table A. If there is no match, the left side will contain null.
Ø  FULL OUTER JOIN: produces the set of all records in Table A and Table B, with matching records from both sides where available. If there is no match, the missing side will contain null.
Ø  INNER JOIN: produces only the set of records that match in both Table A and Table B.



Posted by at

9 comments:

  1. Anonymous7 July 2014 at 08:13

    great

    ReplyDelete
  2. Unknown16 December 2015 at 23:56

    Wow !!
    Its easy to understand.
    Good.

    ReplyDelete
  3. Evan6 September 2018 at 00:26

    Nice visual illustration of SQL joins. Its easy to understand with set theory. I've tried nested ones with venn diagrams as well. Found some great examples in the diagram community of Creately. Might be useful for programmers. You can find more ready to use (customizable) Venn diagram templates in the diagram community of Creately. You can use and try them for free.

    ReplyDelete
  4. Shahid Siddique19 October 2020 at 05:24

    This comment has been removed by the author.

    ReplyDelete
  5. Shahid Siddique19 October 2020 at 05:25

    Thanks, great explanation, I linked your article for reference at SQL joins , if that's okay with you.

    ReplyDelete
  6. Bhaumik Patel19 October 2020 at 19:23

    I am ok with that, I am glad you have liked it. Thank you.

    ReplyDelete
  7. Amy David25 January 2021 at 02:58

    Venn diagram shows all possible logical relations between a finite collection of different sets. You can refer to different types of blogs and other resources which will help you to figure out easy templates in order to draw Venn diagrams easily.

    ReplyDelete
  8. Brooklyn21 September 2023 at 04:53

    A Venn diagram visually illustrates relationships and commonalities between sets. 3 Best Ark In the context of "7," it could represent the overlapping characteristics or elements shared by seven distinct entities.

    ReplyDelete

Subscribe to: Post Comments (Atom)