SQL Joins Visualizer |
Written by Kay Ewbank | |||
Thursday, 08 January 2015 | |||
If you’re learning SQL (or teaching someone else), working out which Join you need can be confusing. A newly released open source utility provides both explanations and code.
SQL Joins Visualizer is an open source app that lets you click on sectors in a Venn diagram to choose how the tables should be combined. ANSI-standard SQL specifies five types of JOIN: INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER and CROSS. You can also create a self-join to join a table to itself. When you’ve clicked on the segments, the SQL Joins Visualizer shows you the SQL that corresponds to your selection, and you can copy and paste it if you need the SQL code elsewhere. The app also gives you a description of the join you’ve created. So, for example, if you click on the right-hand segment and the central segment, you get a description telling you that a “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”. You also get the SQL:
This is a very simple app, but it would be a good teaching aid. It is available online, and will also work offline
You can read more about the app and SQL joins in general in a post on the Leopard blog from the app’s author, Alexey Vasiliev.
More InformationRelated Articles
|
Kafka 4 Adds Queue Semantics Support 17/04/2025 Kafka 4.0 has been released, with major changes. This is the first version to operate entirely in KRaft mode by default. It also adds a new consumer group protocol designed to dramatically improve reb [ ... ] |
Get Ready For Pure Virtual C++ 2025 Conference 22/04/2025 Pure Virtual C++ is Micorosft's free, one-day, virtual conference for the whole C++ community. This year, it is running on April 30th. |
More News
|
Comments
or email your comment to: comments@i-programmer.info