![]() ![]() We’ll start with something very familiar. This stands for joins where you join using FK, but also for joins where you compare attributes that are not part of a foreign key (this is rarely used). Calling such “standard” joins an equi-joins is just a fancy way to name it. So, what are equi-joins? Equi-joins are standard joins where you’ll use the equality operator (=) while joining tables. The reason for that is that they are so common, and the whole idea of databases is related to joining tables in such a manner. You’ve used equi-joins so far, and you’ve probably never called them that way. If you need to refresh your knowledge related to primary and foreign keys, select statement, and inner and left joins, this would be the right time to do it.Įqui-Joins vs. We’ll use only two tables from this model city and country, and we’ll comment on the data later in this article while taking a look at few non-equi join SQL Server queries. ![]() If you’re still not familiar with it, take some time to see how the tables are related to each other. On this part, nothing has changed since the last article, so we’ll use the same model we’re using throughout this series. Today’ I’ll try to explain what they are and when you should use them. After reading this article, I hope you’ll agree on that with me. Non-Equi join in SQL Server sounds like something abstract (and fancy), but it’s not so abstract (and fancy) at all. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |