How to Make a Join Easier to Read using Table Aliases

I recently put together a lesson on table aliases and multi-table joins.

You’ll find that as you write more complicated joins, that the SQL can become harder to read, as you’ll need to qualify column with table names to avoid ambiguity. To make you SQL more compact and more readable you can create table aliases.

Read More: SQL Joins – The Ultimate Guide >>

The aliases become a short-hand naming convention. That way, instead of referring to Person.PersonPhone.BusinessEntityID we can create the alias PP for Person.PersonPhone and simply refer to the column as PP.BusinessEntityID.

You can learn more about this this video, it’s transcript follows:

</p> <h2 class="wp-block-heading" id="h-how-to-make-join-easier-to-read-using-table-aliases-transcript">How to Make Join easier to Read using Table Aliases Transcript</h2> <p>In this lesson we’re going to talk about table aliases and multi-table joins.</p> <p>So, why do we use table aliases? Well, as joins get more complicated, it makes sense to use table aliases.  Remember, table aliases are a way of renaming the table name giving it a shorter name.  And it makes the SQL easier to read.</p> <figure class="wp-block-image alignnone"><a href="https://www.essentialsql.com/wp-content/uploads/2018/07/Why-Use-Table-Aliases.png"><img decoding="async" src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-src="https://www.essentialsql.com/wp-content/uploads/2018/07/Why-Use-Table-Aliases.png" alt="Reasons to use a Table Alias" class="wp-image-4954 lazyload"/><noscript><img fetchpriority="high" decoding="async" width="650" height="372" src="https://www.essentialsql.com/wp-content/uploads/2018/07/Why-Use-Table-Aliases.png" alt="Reasons to use a Table Alias" class="wp-image-4954 lazyload" srcset="https://www.essentialsql.com/wp-content/uploads/2018/07/Why-Use-Table-Aliases.png 650w, https://www.essentialsql.com/wp-content/uploads/2018/07/Why-Use-Table-Aliases-300x172.png 300w" sizes="(max-width: 650px) 100vw, 650px" /></noscript></a><figcaption>Why Use Table Aliases</figcaption></figure> <p>It also, since it’s a shorter name, you’re less apt to make a typing mistake, and when you’re working with multiple tables, especially those that have, maybe the same columns within them, it helps avoid <a href="https://www.quora.com/What-does-the-SQL-ambiguous-column-name-error-mean" target="_blank" rel="noopener">ambiguous column names</a>.  Meaning, are you picking the business entity ID from the employee table or from the person table? By being able to use an alias and always prefixing the column name with that alias, you know exactly what table you’re grabbing the column from.</p> <p>So let’s look at some examples.  So here’s a table alias example.</p> <figure class="wp-block-image alignnone"><a href="https://www.essentialsql.com/wp-content/uploads/2018/07/Table-Alias-Example.png"><img decoding="async" src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-src="https://www.essentialsql.com/wp-content/uploads/2018/07/Table-Alias-Example.png" alt="SQL using Table Aliases - Before versus After" class="wp-image-4955 lazyload"/><noscript><img decoding="async" width="650" height="351" src="https://www.essentialsql.com/wp-content/uploads/2018/07/Table-Alias-Example.png" alt="SQL using Table Aliases - Before versus After" class="wp-image-4955 lazyload" srcset="https://www.essentialsql.com/wp-content/uploads/2018/07/Table-Alias-Example.png 650w, https://www.essentialsql.com/wp-content/uploads/2018/07/Table-Alias-Example-300x162.png 300w" sizes="(max-width: 650px) 100vw, 650px" /></noscript></a><figcaption>Table Alias – Before and After</figcaption></figure> <p>In the top you can see an <a href="https://www.essentialsql.com/sql-inner-join/">INNER JOIN</a> that we’ve worked on in the past, where we specified the join using only table names.  We’re selecting the FirstName from the Person table, the LastName from the Person table, the PhoneNumber from the PersonPhone table.  The join condition is on the Person and the PersonPhone table.  And we’re matching by BusinessEntityID.</p> <pre class="wp-block-preformatted">SELECT Person.FirstName,        Person.LastName,        PersonPhone.PhoneNumber FROM   Person.Person        INNER JOIN Person.PersonPhone        ON Person.BusinessEntityID = PersonPhone.BusinessEntityID</pre> <p>There’s a lot here.  It can be simplified by using table aliases.  It kind of tightens up the SQL.  And how we do that is by putting the alias at the end of the table name.</p> <p>Notice how the each column is prefix by some letters.  Those are the table aliases.  The first alias is named in the FROM clause, the second in the INNER JOIN.</p> <pre class="wp-block-preformatted">SELECT P.FirstName,        P.LastName,        PP.PhoneNumber FROM   Person.Person P        INNER JOIN Person.PersonPhone PP        ON P.BusinessEntityID = PP.BusinessEntityID</pre> <p>Well if we go down into our INNER JOIN, we’ll see that we are doing an inner join on Person.PersonPhone.  And we alias with PP.  Now, when we reference any column from PersonPhone, we can just use PP as the alias.  So we have, for our for our join condition then, a join condition on table alias P.BusinessEntityID = PP.BusinessEntityID.</p> <p>I personally think this makes it easier to read.  It’s easy to type.  I’m less apt to make mistakes.  I will caution you though, that if you start using table aliases that are a little arcane, and you have lots of tables in your joins, after a while, it can be easy to forget which letters go with which tables.  So there is a trade-off there, in terms of readability.  And you want to be aware of that.</p> <h2 class="wp-block-heading" id="h-joining-multiple-tables-using-table-aliases">Joining Multiple Tables Using Table Aliases</h2> <p>Now let’s move on to joining three tables.  And this is really where you start wanting to use table aliases because the more tables you have in your SQL, the bigger your SQL statements get, and the easier I think it is to manage once you can alias.</p> <p>We’re going to create a query where we’re pulling columns from each of these tables.  Now we already know how to do a join with two tables.  In fact, through some of our examples, we’ve already done a join where we’ve joined person with person phone.  And then we’ve also done an example where we joined person phone with phone number type.</p> <figure class="wp-block-image alignnone"><a href="https://www.essentialsql.com/wp-content/uploads/2018/07/Joining-Three-Tables.png"><img decoding="async" src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-src="https://www.essentialsql.com/wp-content/uploads/2018/07/Joining-Three-Tables.png" alt="Joining Three Tables - The Queries Two Tables at a Time" class="wp-image-4957 lazyload"/><noscript><img decoding="async" width="650" height="360" src="https://www.essentialsql.com/wp-content/uploads/2018/07/Joining-Three-Tables.png" alt="Joining Three Tables - The Queries Two Tables at a Time" class="wp-image-4957 lazyload" srcset="https://www.essentialsql.com/wp-content/uploads/2018/07/Joining-Three-Tables.png 650w, https://www.essentialsql.com/wp-content/uploads/2018/07/Joining-Three-Tables-300x166.png 300w" sizes="(max-width: 650px) 100vw, 650px" /></noscript></a><figcaption>The Queries Two Tables at a Time</figcaption></figure> <p>And you can see that I’ve put these queries down here below.  Once query obtain the employee name and their phone number, the other the phone number and type.</p> <p>So the big question is how can I write a join that pulls all this together? And the simple answer is that we can have more than one inner join clause in our SQL.  I’d like to show you how to do that right now.</p> <p>I’m going to start out and I’m going to select from Person, INNER JOIN on PersonPhone.  And then we’ll do our join clause.  So this should look very familiar.</p> <pre class="wp-block-preformatted">SELECT P.FirstName,        P.LastName,        PP.PhoneNumber FROM   Person.Person P        INNER JOIN Person.PersonPhone PP        ON P.BusinessEntityID = PP.BusinessEntityID</pre> <p>I’m going to indent this out a little bit.  I know this is going to come out to here.  This inner join’s going to …  I’m going to move this out.  And we’ll move this out.</p> <p>So, so far what we’re doing is we’re going to join the Person table to the PersonPhone table using the BusinessEntityID column.  Now, what we’re going to do is go and join from<span style="color: #ff0000;"> PersonPhone</span> to <span style="color: #ff0000;">PhoneNumberType</span>.  To do that I just add another inner join clause.  I’ll alias that as PT on. Then I can say <span style="color: #ff0000;">PersonPhone.PhoneNumberTypeID equals PT.PhoneNumberTypeID</span>.</p> <pre class="wp-block-preformatted">SELECT P.FirstName,        P.LastName,        PP.PhoneNumber,        PT.Name FROM   Person.Person P        INNER JOIN <span style="color: #ff0000;">Person.PersonPhone PP</span>        ON P.BusinessEntityID = PP.BusinessEntityID        <span style="color: #ff0000;">INNER JOIN Person.PhoneNumberType PT</span> <span style="color: #ff0000;">       ON PP.PhoneNumberTypeID = PT.PhoneNumberTypeID</span></pre> <p>So, as you can imagine, what we’re doing is we’re linking a person to their phone number using their unique ID, which is the BusinessEntityID.  And then when we’re on the PhoneNumber table, to know what type of phone number it is, we’re going to link to the PhoneNumberType and then we’ll get the name.</p> <p>Let’s run the query.  So now we’re bringing in the first name and last name from the person table.  The phone number from the phone number table.  And then the type from the phone number type table.</p> <p>so here’s the first table, person.  We’re joining to person phone.  That’s where we get the phone number.  We’re linking on business entity ID, because we’re using the person to link to what their phone number is.  And then we’re doing a second join.  We’re going to link in phone number type.  And the main reason we’re doing this is we need to understand what type of phone number we have on the person phone record.  We know there’s a phone number type ID.  So we’re going to use that as our match to look up and bring in the phone number type record.  And the reason we’re doing that is so that we can get the phone type name, and display that as the phone number type.</p> <p>So now that you’ve seen this as a query, I’m going to go back to our slide and show you how this is all related.  And we’ll walk through it again on the slide.</p> <p>The three tables that we joined together, along with the SQL that we used to do so.  So our objective was to display the person, their first and last name, their phone number, and then the type of phone they have listed.  To do this, we used the person’s business entity ID, which is their unique identifier, to link to the person phone record.  At this point we may bring back one or more phone record for that person.</p> <p>Now we need to understand what type of phone we are talking about within the listing.  To understand that we used the phone number type ID to link to the phone number type table to retrieve the name.  This is shown in the SQL where we’re selecting the first name and last name from person, the person phone phone number, and the person phone number type.  These are all aliased.</p> <figure class="wp-block-image alignnone"><a href="https://www.essentialsql.com/wp-content/uploads/2018/07/Joining-Three-Tables-Final-Query.png"><img decoding="async" src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-src="https://www.essentialsql.com/wp-content/uploads/2018/07/Joining-Three-Tables-Final-Query.png" alt="Joining Three Tables - Final Query and Table Aliases" class="wp-image-4958 lazyload"/><noscript><img decoding="async" width="650" height="350" src="https://www.essentialsql.com/wp-content/uploads/2018/07/Joining-Three-Tables-Final-Query.png" alt="Joining Three Tables - Final Query and Table Aliases" class="wp-image-4958 lazyload" srcset="https://www.essentialsql.com/wp-content/uploads/2018/07/Joining-Three-Tables-Final-Query.png 650w, https://www.essentialsql.com/wp-content/uploads/2018/07/Joining-Three-Tables-Final-Query-300x162.png 300w" sizes="(max-width: 650px) 100vw, 650px" /></noscript></a><figcaption>Joining Three Tables – Final Query</figcaption></figure> <p>You’ll see that there is the main table, person, alias with a P.  And then I have two join clauses.  One to person phone, and another join clause to person phone type.  Also notice that these clauses are the join condition where we are, in one case, joining on business entity ID.  And in the second we are joining on phone number type ID.</p> <p>so as you can see, joining between two tables and three tables is not that much different.  So I hope you enjoyed this lesson.  And I’ll see you in the next.</p> </div></div> <div class="wp-block-group swt-block-comment-group has-surface-background-color has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained" style="padding-top:var(--wp--preset--spacing--x-small);padding-right:var(--wp--preset--spacing--medium);padding-bottom:var(--wp--preset--spacing--x-small);padding-left:var(--wp--preset--spacing--medium)"> <div class="wp-block-comments"><h5 id="comments" style="margin-top:var(--wp--preset--spacing--large);" class="wp-block-comments-title">One response to “How to Make a Join Easier to Read using Table Aliases”</h5> <ol class="wp-block-comment-template"><li id="comment-2029266" class="comment even thread-even depth-1"> <div class="wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained" style="border-top-color:var(--wp--preset--color--outline);border-top-width:1px;border-right-style:none;border-right-width:0px;border-bottom-style:none;border-bottom-width:0px;border-left-style:none;border-left-width:0px;padding-top:var(--wp--preset--spacing--medium);padding-bottom:var(--wp--preset--spacing--medium)"> <div class="wp-block-group is-nowrap is-layout-flex wp-container-core-group-is-layout-8 wp-block-group-is-layout-flex"><div class="wp-block-avatar"> </div> <div class="wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-7 wp-block-group-is-layout-flex"><div class="wp-block-comment-author-name has-small-font-size">shah</div> <div class="wp-block-group is-layout-flex wp-container-core-group-is-layout-6 wp-block-group-is-layout-flex"><div class="has-text-color has-neutral-color wp-block-comment-date has-x-small-font-size"><time datetime="2020-12-23T21:58:01-05:00">Dec 23, 2020</time></div> </div> </div> </div> <div class="wp-block-comment-content"><p>well explained</p> </div> <div class="wp-block-comment-reply-link has-small-font-size"><a rel='nofollow' class='comment-reply-link' href='#comment-2029266' data-commentid="2029266" data-postid="4944" data-belowelement="comment-2029266" data-respondelement="respond" data-replyto="Reply to shah" aria-label='Reply to shah'>Reply</a></div></div> </li></ol> <div id="respond" class="comment-respond wp-block-post-comments-form"> <h3 id="reply-title" class="comment-reply-title">Leave a Reply <small><a rel="nofollow" id="cancel-comment-reply-link" href="/make-join-easier-read-using-table-aliases/#respond" style="display:none;">Cancel reply</a></small></h3><form action="https://www.essentialsql.com/wp-comments-post.php" method="post" id="commentform" class="comment-form" novalidate><p class="comment-notes"><span id="email-notes">Your email address will not be published.</span> <span class="required-field-message">Required fields are marked <span class="required">*</span></span></p><p class="comment-form-comment"><label for="comment">Comment <span class="required">*</span></label> <textarea id="comment" name="comment" cols="45" rows="8" maxlength="65525" required></textarea></p><p class="comment-form-author"><label for="author">Name <span class="required">*</span></label> <input id="author" name="author" type="text" value="" size="30" maxlength="245" autocomplete="name" required /></p> <p class="comment-form-email"><label for="email">Email <span class="required">*</span></label> <input id="email" name="email" type="email" value="" size="30" maxlength="100" aria-describedby="email-notes" autocomplete="email" required /></p> <p class="comment-form-url"><label for="url">Website</label> <input id="url" name="url" type="url" value="" size="30" maxlength="200" autocomplete="url" /></p> <p class="form-submit wp-block-button"><input name="submit" type="submit" id="submit" class="wp-block-button__link wp-element-button" value="Post Comment" /> <input type='hidden' name='comment_post_ID' value='4944' id='comment_post_ID' /> <input type='hidden' name='comment_parent' id='comment_parent' value='0' /> </p><p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="42af983af8" /></p><p style="display: none !important;" class="akismet-fields-container" data-prefix="ak_"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="190"/><script>document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() );</script></p></form> </div> <p class="akismet_comment_form_privacy_notice">This site uses Akismet to reduce spam. <a href="https://akismet.com/privacy/" target="_blank" rel="nofollow noopener">Learn how your comment data is processed</a>.</p></div> </div> </div> <div class="wp-block-column is-layout-flow wp-block-column-is-layout-flow" style="padding-left:var(--wp--preset--spacing--small);flex-basis:25%"><div class="wp-block-template-part"> <div class="wp-block-uagb-table-of-contents uagb-toc__align-left uagb-toc__columns-1 uagb-block-c612fbdc " data-scroll= "1" data-offset= "30" style="" > <div class="uagb-toc__wrap"> <div class="uagb-toc__title"> Table Of Contents </div> <div class="uagb-toc__list-wrap"> <ol class="uagb-toc__list"><li class="uagb-toc__list"><a href="#how-to-make-join-easier-to-read-using-table-aliases-transcript" class="uagb-toc-link__trigger">How to Make Join easier to Read using Table Aliases Transcript</a><li class="uagb-toc__list"><a href="#joining-multiple-tables-using-table-aliases" class="uagb-toc-link__trigger">Joining Multiple Tables Using Table Aliases</a></ol> </div> </div> </div> <h6 class="wp-block-heading" id="h-more-from-the-blog" style="font-style:normal;font-weight:500;text-transform:uppercase">More from the blog</h6> <hr class="wp-block-separator has-alpha-channel-opacity is-style-swt-separator-wide-thin-line" style="margin-top:var(--wp--preset--spacing--medium);margin-bottom:var(--wp--preset--spacing--medium)"/> <ul class="wp-block-latest-posts__list is-style-swt-latest-posts-simple wp-block-latest-posts swt-has-featured-image"> <li> <div class="wp-block-latest-posts__featured-image"><a href="https://www.essentialsql.com/understanding-relational-databases-a-beginners-guide/" aria-label="Understanding Relational Databases: A Beginner’s Guide"><img width="150" height="150" src="https://www.essentialsql.com/wp-content/uploads/2024/06/Relational-Database-150x150.png" class="attachment-thumbnail size-thumbnail wp-post-image" alt="" style="" decoding="async"></a></div> <a class="wp-block-latest-posts__post-title" href="https://www.essentialsql.com/understanding-relational-databases-a-beginners-guide/">Understanding Relational Databases: A Beginner’s Guide</a> </li> <li> <div class="wp-block-latest-posts__featured-image"><a href="https://www.essentialsql.com/sql-outer-join-tutorial/" aria-label="SQL Outer Join Tutorial"><img width="150" height="150" src="https://www.essentialsql.com/wp-content/uploads/2024/05/OuterJoin-Small-150x150.jpg" class="attachment-thumbnail size-thumbnail wp-post-image" alt="" style="" decoding="async"></a></div> <a class="wp-block-latest-posts__post-title" href="https://www.essentialsql.com/sql-outer-join-tutorial/">SQL Outer Join Tutorial</a> </li> <li> <div class="wp-block-latest-posts__featured-image"><a href="https://www.essentialsql.com/sql-inner-join-tutorial/" aria-label="SQL Inner Join Tutorial"><img width="150" height="150" src="https://www.essentialsql.com/wp-content/uploads/2024/05/Inner-join-150x150.jpg" class="attachment-thumbnail size-thumbnail wp-post-image" alt="" style="" decoding="async"></a></div> <a class="wp-block-latest-posts__post-title" href="https://www.essentialsql.com/sql-inner-join-tutorial/">SQL Inner Join Tutorial</a> </li> <li><a class="wp-block-latest-posts__post-title" href="https://www.essentialsql.com/sql-joins-tutorial/">SQL Joins: Exploring the Power of Table Combining</a></li> <li> <div class="wp-block-latest-posts__featured-image"><a href="https://www.essentialsql.com/sql-count-and-other-aggregate-functions-tutorial/" aria-label="Understanding SQL COUNT and Other Aggregate Function"><img width="150" height="150" src="https://www.essentialsql.com/wp-content/uploads/2024/05/SQL-Counts-and-Summarization-150x150.jpg" class="attachment-thumbnail size-thumbnail wp-post-image" alt="" style="" decoding="async" srcset="https://www.essentialsql.com/wp-content/uploads/2024/05/SQL-Counts-and-Summarization-150x150.jpg 150w, https://www.essentialsql.com/wp-content/uploads/2024/05/SQL-Counts-and-Summarization-300x300.jpg 300w, https://www.essentialsql.com/wp-content/uploads/2024/05/SQL-Counts-and-Summarization.jpg 498w" sizes="(max-width: 150px) 100vw, 150px"></a></div> <a class="wp-block-latest-posts__post-title" href="https://www.essentialsql.com/sql-count-and-other-aggregate-functions-tutorial/">Understanding SQL COUNT and Other Aggregate Function</a> </li> </ul> <h6 class="wp-block-heading has-x-small-font-size" id="h-recommended-topics" style="font-style:normal;font-weight:500;text-transform:uppercase">Recommended Topics</h6> <div class="wp-block-categories-dropdown is-style-swt-categories-minimal wp-block-categories"><label class="screen-reader-text" for="wp-block-categories-1">Categories</label><select name='cat' id='wp-block-categories-1' class='postform'> <option value='-1'>Select Category</option> <option class="level-0" value="2004162">Blog</option> <option class="level-1" value="2004204">   Data Modification</option> <option class="level-1" value="2004198">   SQL Database</option> <option class="level-1" value="2004190">   SQL DataTypes</option> <option class="level-1" value="2004238">   SQL DBA</option> <option class="level-1" value="2004176">   SQL Functions</option> <option class="level-2" value="2004189">      SQL Aggregate Functions</option> <option class="level-2" value="2004183">      SQL Conversion Functions</option> <option class="level-2" value="2004181">      SQL Date Functions</option> <option class="level-2" value="2004182">      SQL Logical Functions</option> <option class="level-2" value="2004180">      SQL Mathematical Functions</option> <option class="level-2" value="2004179">      SQL String Functions</option> <option class="level-1" value="2004165">   SQL Programming</option> <option class="level-1" value="2004172">   SQL Queries</option> <option class="level-2" value="2004203">      Common Table Expressions</option> <option class="level-2" value="2004187">      Database Joins</option> <option class="level-2" value="2004188">      Database Queries</option> <option class="level-2" value="2004186">      Set Operators</option> <option class="level-2" value="2004185">      SQL Subqueries</option> <option class="level-2" value="2004211">      Summarizing Data</option> <option class="level-2" value="2004207">      Window Functions</option> <option class="level-1" value="2004196">   SQL Recipies</option> <option class="level-0" value="2004192">Getting Started</option> <option class="level-0" value="2004208">Good SQL Questions</option> <option class="level-0" value="2004209">SQL How To</option> <option class="level-0" value="2004210">SQL Puzzles</option> <option class="level-0" value="2004237">SQL Tutorials</option> <option class="level-0" value="2004174">Uncategorized</option> </select><script> ( function() { var dropdown = document.getElementById( 'wp-block-categories-1' ); function onCatChange() { if ( dropdown.options[ dropdown.selectedIndex ].value > 0 ) { location.href = "https://www.essentialsql.com/?cat=" + dropdown.options[ dropdown.selectedIndex ].value; } } dropdown.onchange = onCatChange; })(); </script> </div> <hr class="wp-block-separator has-alpha-channel-opacity is-style-swt-separator-wide-thin-line" style="margin-top:var(--wp--preset--spacing--medium);margin-bottom:var(--wp--preset--spacing--medium)"/> <h6 class="wp-block-heading has-x-small-font-size" id="h-popular-tags" style="font-style:normal;font-weight:500;text-transform:uppercase">Popular Tags</h6> <p class="is-style-swt-tag-cloud-pill wp-block-tag-cloud"><a href="https://www.essentialsql.com/tag/mysql/" class="tag-cloud-link tag-link-2004201 tag-link-position-1" style="font-size: 15.583333333333pt;" aria-label="MySQL (27 items)">MySQL</a> <a href="https://www.essentialsql.com/tag/postgresql/" class="tag-cloud-link tag-link-2004200 tag-link-position-2" style="font-size: 15.583333333333pt;" aria-label="PostgreSQL (27 items)">PostgreSQL</a> <a href="https://www.essentialsql.com/tag/sqlite/" class="tag-cloud-link tag-link-2004170 tag-link-position-3" style="font-size: 8pt;" aria-label="SQLite (20 items)">SQLite</a> <a href="https://www.essentialsql.com/tag/sqlserver/" class="tag-cloud-link tag-link-2004199 tag-link-position-4" style="font-size: 22pt;" aria-label="SQL Server (35 items)">SQL Server</a></p> <hr class="wp-block-separator has-alpha-channel-opacity is-style-swt-separator-wide-thin-line" style="margin-top:var(--wp--preset--spacing--medium);margin-bottom:var(--wp--preset--spacing--medium)"/> </div></div> </div> </div> </div> <footer class="wp-block-template-part"> <div class="wp-block-uagb-container uagb-block-b4ec969e alignfull uagb-is-root-container"><div class="uagb-container-inner-blocks-wrap"> <div class="wp-block-uagb-container uagb-layout-flex uagb-block-f912f87a"> <div class="wp-block-uagb-container uagb-block-8975db66"> <div class="wp-block-uagb-call-to-action uagb-block-5d593cfe wp-block-button"><div class="uagb-cta__wrap"><h3 class="uagb-cta__title">Get Started Learning SQL!</h3><p class="uagb-cta__desc">Most business analysts don’t know where to start learning SQL. <br><br>At EssentialSQL we have an easy-to-understand plan, which results in you learning SQL frustration free at the right time in the right order.</p></div><div class="uagb-cta__buttons"><a href="https://fearless.essentialsql.com/pl/2148392046" class="uagb-cta__button-link-wrapper wp-block-button__link" target="_self" rel="noopener noreferrer">Get Your Free Course Today<svg xmlns="https://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M504.3 273.6l-112.1 104c-6.992 6.484-17.18 8.218-25.94 4.406c-8.758-3.812-14.42-12.45-14.42-21.1L351.9 288H32C14.33 288 .0002 273.7 .0002 255.1S14.33 224 32 224h319.9l0-72c0-9.547 5.66-18.19 14.42-22c8.754-3.809 18.95-2.075 25.94 4.41l112.1 104C514.6 247.9 514.6 264.1 504.3 273.6z"></path></svg></a></div></div> </div> </div> </div></div> <div class="wp-block-group has-global-padding is-content-justification-center is-layout-constrained wp-container-core-group-is-layout-14 wp-block-group-is-layout-constrained" style="margin-top:0;margin-bottom:0;padding-top:0;padding-bottom:var(--wp--preset--spacing--medium)"> <div class="wp-block-uagb-container uagb-block-8da89837 alignfull uagb-is-root-container"><div class="uagb-container-inner-blocks-wrap"> <div class="wp-block-columns alignwide is-layout-flex wp-container-core-columns-is-layout-3 wp-block-columns-is-layout-flex" style="margin-top:var(--wp--preset--spacing--x-small);margin-bottom:var(--wp--preset--spacing--x-small)"> <div class="wp-block-column is-layout-flow wp-block-column-is-layout-flow" style="padding-bottom:var(--wp--preset--spacing--xx-small)"> <figure class="wp-block-image size-full swt-duotone-secondary site-logo-img"><img decoding="async" width="250" height="38" src="https://www.essentialsql.com/wp-content/uploads/2024/04/Logo-WebSitex250.png" alt="" class="wp-image-2014757"/></figure> <p class="has-background-color has-text-color has-link-color has-small-font-size wp-elements-34c0dd419f246b0b2296461fe47d97e8" style="padding-right:var(--wp--preset--spacing--medium)">Your search for SQL training is over.</p> <ul class="wp-block-social-links has-small-icon-size has-icon-color is-style-logos-only is-layout-flex wp-container-core-social-links-is-layout-1 wp-block-social-links-is-layout-flex"><li style="color: #ECFDF6; " class="wp-social-link wp-social-link-facebook has-tertiary-color wp-block-social-link"><a rel="noopener nofollow" target="_blank" href="https://www.facebook.com/essentialsql" class="wp-block-social-link-anchor"><svg width="24" height="24" viewBox="0 0 24 24" version="1.1" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false"><path d="M12 2C6.5 2 2 6.5 2 12c0 5 3.7 9.1 8.4 9.9v-7H7.9V12h2.5V9.8c0-2.5 1.5-3.9 3.8-3.9 1.1 0 2.2.2 2.2.2v2.5h-1.3c-1.2 0-1.6.8-1.6 1.6V12h2.8l-.4 2.9h-2.3v7C18.3 21.1 22 17 22 12c0-5.5-4.5-10-10-10z"></path></svg><span class="wp-block-social-link-label screen-reader-text">Facebook</span></a></li> <li style="color: #ECFDF6; " class="wp-social-link wp-social-link-twitter has-tertiary-color wp-block-social-link"><a rel="noopener nofollow" target="_blank" href="https://twitter.com/sqlkris" class="wp-block-social-link-anchor"><svg width="24" height="24" viewBox="0 0 24 24" version="1.1" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false"><path d="M22.23,5.924c-0.736,0.326-1.527,0.547-2.357,0.646c0.847-0.508,1.498-1.312,1.804-2.27 c-0.793,0.47-1.671,0.812-2.606,0.996C18.324,4.498,17.257,4,16.077,4c-2.266,0-4.103,1.837-4.103,4.103 c0,0.322,0.036,0.635,0.106,0.935C8.67,8.867,5.647,7.234,3.623,4.751C3.27,5.357,3.067,6.062,3.067,6.814 c0,1.424,0.724,2.679,1.825,3.415c-0.673-0.021-1.305-0.206-1.859-0.513c0,0.017,0,0.034,0,0.052c0,1.988,1.414,3.647,3.292,4.023 c-0.344,0.094-0.707,0.144-1.081,0.144c-0.264,0-0.521-0.026-0.772-0.074c0.522,1.63,2.038,2.816,3.833,2.85 c-1.404,1.1-3.174,1.756-5.096,1.756c-0.331,0-0.658-0.019-0.979-0.057c1.816,1.164,3.973,1.843,6.29,1.843 c7.547,0,11.675-6.252,11.675-11.675c0-0.178-0.004-0.355-0.012-0.531C20.985,7.47,21.68,6.747,22.23,5.924z"></path></svg><span class="wp-block-social-link-label screen-reader-text">Twitter</span></a></li> <li style="color: #ECFDF6; " class="wp-social-link wp-social-link-youtube has-tertiary-color wp-block-social-link"><a rel="noopener nofollow" target="_blank" href="https://www.youtube.com/c/EssentialSQL" class="wp-block-social-link-anchor"><svg width="24" height="24" viewBox="0 0 24 24" version="1.1" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false"><path d="M21.8,8.001c0,0-0.195-1.378-0.795-1.985c-0.76-0.797-1.613-0.801-2.004-0.847c-2.799-0.202-6.997-0.202-6.997-0.202 h-0.009c0,0-4.198,0-6.997,0.202C4.608,5.216,3.756,5.22,2.995,6.016C2.395,6.623,2.2,8.001,2.2,8.001S2,9.62,2,11.238v1.517 c0,1.618,0.2,3.237,0.2,3.237s0.195,1.378,0.795,1.985c0.761,0.797,1.76,0.771,2.205,0.855c1.6,0.153,6.8,0.201,6.8,0.201 s4.203-0.006,7.001-0.209c0.391-0.047,1.243-0.051,2.004-0.847c0.6-0.607,0.795-1.985,0.795-1.985s0.2-1.618,0.2-3.237v-1.517 C22,9.62,21.8,8.001,21.8,8.001z M9.935,14.594l-0.001-5.62l5.404,2.82L9.935,14.594z"></path></svg><span class="wp-block-social-link-label screen-reader-text">YouTube</span></a></li> <li style="color: #ECFDF6; " class="wp-social-link wp-social-link-linkedin has-tertiary-color wp-block-social-link"><a rel="noopener nofollow" target="_blank" href="https://www.linkedin.com/in/kriswenzel/" class="wp-block-social-link-anchor"><svg width="24" height="24" viewBox="0 0 24 24" version="1.1" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false"><path d="M19.7,3H4.3C3.582,3,3,3.582,3,4.3v15.4C3,20.418,3.582,21,4.3,21h15.4c0.718,0,1.3-0.582,1.3-1.3V4.3 C21,3.582,20.418,3,19.7,3z M8.339,18.338H5.667v-8.59h2.672V18.338z M7.004,8.574c-0.857,0-1.549-0.694-1.549-1.548 c0-0.855,0.691-1.548,1.549-1.548c0.854,0,1.547,0.694,1.547,1.548C8.551,7.881,7.858,8.574,7.004,8.574z M18.339,18.338h-2.669 v-4.177c0-0.996-0.017-2.278-1.387-2.278c-1.389,0-1.601,1.086-1.601,2.206v4.249h-2.667v-8.59h2.559v1.174h0.037 c0.356-0.675,1.227-1.387,2.526-1.387c2.703,0,3.203,1.779,3.203,4.092V18.338z"></path></svg><span class="wp-block-social-link-label screen-reader-text">LinkedIn</span></a></li></ul> </div> <div class="wp-block-column is-layout-flow wp-container-core-column-is-layout-5 wp-block-column-is-layout-flow" style="padding-bottom:var(--wp--preset--spacing--xx-small)"> <div class="wp-block-columns is-not-stacked-on-mobile is-layout-flex wp-container-core-columns-is-layout-2 wp-block-columns-is-layout-flex"> <div class="wp-block-column is-layout-flow wp-block-column-is-layout-flow"><nav class="has-text-color has-background-color items-justified-left is-vertical wp-block-navigation is-content-justification-left is-layout-flex wp-container-core-navigation-is-layout-2 wp-block-navigation-is-layout-flex" aria-label="Footer LearnSQL"><ul class="wp-block-navigation__container"> <li class=" wp-block-navigation-item wp-block-navigation-link"><a class="wp-block-navigation-item__content" href="https://www.essentialsql.com/sql-courses/"><span class="wp-block-navigation-item__label">Online Courses</span></a></li> <li class=" wp-block-navigation-item wp-block-navigation-link"><a class="wp-block-navigation-item__content" href="https://www.essentialsql.com/getting-started/"><span class="wp-block-navigation-item__label">Start Here</span></a></li> </ul></nav> </div> </div> </div> <div class="wp-block-column is-layout-flow wp-block-column-is-layout-flow"><nav class="has-text-color has-background-color items-justified-left is-vertical wp-block-navigation is-content-justification-left is-layout-flex wp-container-core-navigation-is-layout-3 wp-block-navigation-is-layout-flex" aria-label="Footer Company"><ul class="wp-block-navigation__container"> <li class=" wp-block-navigation-item wp-block-navigation-link"><a class="wp-block-navigation-item__content" href="https://www.essentialsql.com/about/"><span class="wp-block-navigation-item__label">About</span></a></li> <li class=" wp-block-navigation-item wp-block-navigation-link"><a class="wp-block-navigation-item__content" href="https://www.essentialsql.com/contact-essential-sql/"><span class="wp-block-navigation-item__label">Contact Us</span></a></li> <li class=" wp-block-navigation-item wp-block-navigation-link"><a class="wp-block-navigation-item__content" href="https://www.essentialsql.com/privacy-policy/"><span class="wp-block-navigation-item__label">Privacy Policy</span></a></li> <li class=" wp-block-navigation-item wp-block-navigation-link"><a class="wp-block-navigation-item__content" href="https://www.essentialsql.com/terms-of-use/"><span class="wp-block-navigation-item__label">Terms of Use</span></a></li> </ul></nav> </div> <div class="wp-block-column is-vertically-aligned-top is-layout-flow wp-container-core-column-is-layout-7 wp-block-column-is-layout-flow" style="border-style:none;border-width:0px"><nav class="has-text-color has-background-color is-responsive wp-block-navigation is-layout-flex wp-block-navigation-is-layout-flex" aria-label="Footer Resources" data-wp-interactive="core/navigation" data-wp-context='{"overlayOpenedBy":{"click":false,"hover":false,"focus":false},"type":"overlay","roleAttribute":"","ariaLabel":"Menu"}'><button aria-haspopup="dialog" aria-label="Open menu" class="wp-block-navigation__responsive-container-open " data-wp-on--click="actions.openMenuOnClick" data-wp-on--keydown="actions.handleMenuKeydown"><svg width="24" height="24" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24" aria-hidden="true" focusable="false"><rect x="4" y="7.5" width="16" height="1.5"></rect><rect x="4" y="15" width="16" height="1.5"></rect></svg></button> <div class="wp-block-navigation__responsive-container " style="" id="modal-2" data-wp-class--has-modal-open="state.isMenuOpen" data-wp-class--is-menu-open="state.isMenuOpen" data-wp-watch="callbacks.initMenu" data-wp-on--keydown="actions.handleMenuKeydown" data-wp-on--focusout="actions.handleMenuFocusout" tabindex="-1"> <div class="wp-block-navigation__responsive-close" tabindex="-1"> <div class="wp-block-navigation__responsive-dialog" data-wp-bind--aria-modal="state.ariaModal" data-wp-bind--aria-label="state.ariaLabel" data-wp-bind--role="state.roleAttribute"> <button aria-label="Close menu" class="wp-block-navigation__responsive-container-close" data-wp-on--click="actions.closeMenuOnClick"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24" width="24" height="24" aria-hidden="true" focusable="false"><path d="M13 11.8l6.1-6.3-1-1-6.1 6.2-6.1-6.2-1 1 6.1 6.3-6.5 6.7 1 1 6.5-6.6 6.5 6.6 1-1z"></path></svg></button> <div class="wp-block-navigation__responsive-container-content" data-wp-watch="callbacks.focusFirstElement" id="modal-2-content"> <ul class="wp-block-navigation__container"> <li class=" wp-block-navigation-item wp-block-navigation-link"><a class="wp-block-navigation-item__content" href="https://www.essentialsql.com/sql-tutorial-for-sql-server/"><span class="wp-block-navigation-item__label">SQL Tutorial</span></a></li> </ul> </div> </div> </div> </div></nav> </div> </div> </div></div> <div class="wp-block-group alignwide is-content-justification-center is-nowrap is-layout-flex wp-container-core-group-is-layout-13 wp-block-group-is-layout-flex"> <p class="has-text-align-center has-x-small-font-size">© 2024 ·</p> <h1 style="font-style:normal;font-weight:400;" class="wp-block-site-title has-x-small-font-size"><a href="https://www.essentialsql.com" target="_self" rel="home">Essential SQL</a></h1> <p class="has-text-align-center has-x-small-font-size">· All rights reserved</p> </div> </div> </footer></div> <div id="ezoic-pub-ad-placeholder-617" data-inserter-version="-1"></div> <script type="text/javascript"> var _paq = _paq || []; _paq.push(['setCustomDimension', 1, '{"ID":1,"name":"Kris Wenzel","avatar":"13a40a57e83218798031b4464200f4b4"}']); _paq.push(['trackPageView']); (function () { var u = "https://stats1.wpmudev.com/"; _paq.push(['setTrackerUrl', u + 'track/']); _paq.push(['setSiteId', '217904']); var d = document, g = d.createElement('script'), s = d.getElementsByTagName('script')[0]; g.type = 'text/javascript'; g.async = true; g.defer = true; g.src = 'https://stats.wpmucdn.com/analytics.js'; s.parentNode.insertBefore(g, s); })(); </script> <script defer src="https://www.essentialsql.com/wp-content/plugins/akismet/_inc/akismet-frontend.js?ver=1720711866" id="akismet-frontend-js"></script> <script src="https://www.essentialsql.com/wp-includes/js/comment-reply.min.js?ver=6.5.5" id="comment-reply-js" async data-wp-strategy="async"></script> <script src="https://www.essentialsql.com/wp-content/plugins/ultimate-addons-for-gutenberg/assets/js/spectra-block-positioning.min.js?ver=2.14.1" id="uagb-block-positioning-js-js"></script> <script src="https://www.essentialsql.com/wp-content/uploads/uag-plugin/assets/2015000/uag-js-2015317.js?ver=1721202787" id="uag-script-2015317-js"></script> <script id="uagb-countdown-js-js-extra"> var uagb_countdown_data = {"site_name_slug":"essential-sql"}; var uagb_countdown_data = {"site_name_slug":"essential-sql"}; var uagb_countdown_data = {"site_name_slug":"essential-sql"}; </script> <script src="https://www.essentialsql.com/wp-content/plugins/spectra-pro/assets/js/uagb-countdown.min.js?ver=2.14.1" id="uagb-countdown-js-js"></script> <script src="https://www.essentialsql.com/wp-content/plugins/ultimate-addons-for-gutenberg/assets/js/uagb-button-child.min.js?ver=2.14.1" id="uagb-button-child-js-js"></script> <script src="https://www.essentialsql.com/wp-content/uploads/uag-plugin/assets/2015000/uag-js-2015316.js?ver=1721202787" id="uag-script-2015316-js"></script> <script id="wp-block-template-skip-link-js-after"> ( function() { var skipLinkTarget = document.querySelector( 'main' ), sibling, skipLinkTargetID, skipLink; // Early exit if a skip-link target can't be located. if ( ! skipLinkTarget ) { return; } /* * Get the site wrapper. * The skip-link will be injected in the beginning of it. */ sibling = document.querySelector( '.wp-site-blocks' ); // Early exit if the root element was not found. if ( ! sibling ) { return; } // Get the skip-link target's ID, and generate one if it doesn't exist. skipLinkTargetID = skipLinkTarget.id; if ( ! skipLinkTargetID ) { skipLinkTargetID = 'wp--skip-link--target'; skipLinkTarget.id = skipLinkTargetID; } // Create the skip link. skipLink = document.createElement( 'a' ); skipLink.classList.add( 'skip-link', 'screen-reader-text' ); skipLink.href = '#' + skipLinkTargetID; skipLink.innerHTML = 'Skip to content'; // Inject the skip link. sibling.parentElement.insertBefore( skipLink, sibling ); }() ); </script> <script src="https://www.essentialsql.com/wp-content/plugins/esql-1.2.2/static/bk-runtime.js?ver=1.2.1" id="esql-run-js"></script> <script src="https://www.essentialsql.com/wp-content/plugins/esql-1.2.2/static/bk-chunk.js?ver=1.2.1" id="esql-c-js"></script> <script src="https://www.essentialsql.com/wp-content/plugins/esql-1.2.2/static/bk-main.js?ver=1.2.1" id="esql-main-js"></script> <script src="https://www.essentialsql.com/wp-content/plugins/sg-cachepress/assets/js/lazysizes.min.js?ver=7.6.2" id="siteground-optimizer-lazy-sizes-js-js"></script> <script src="https://www.essentialsql.com/wp-content/plugins/spectra-pro/assets/js/loop-builder.js?ver=1.1.7" id="uagb-loop-builder-js"></script> <script src="https://www.essentialsql.com/wp-content/themes/spectra-one/assets/js/script.js?ver=1.1.2" id="spectra-one-js"></script> </body> </html>

Do You Want to Learn SQL?

Free Beginners SQL Course!

How to Make a Join Easier to Read using Table Aliases