Tag: outer join

Pro Members SQL Server Standard Members

Troubleshooting problems with joins in SQL Server 2017

by

Troubleshooting problems with joins in SQL Server 2017 If you have problems with joins in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. You may receive an incorrect result when you run a query that uses a parallel execution plan with Merge Semi join. This is SQL Server 2017 bug. To work around this problem, you...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle

Taking Advantage of the OUTER JOIN Syntax

by

Taking Advantage of the OUTER JOIN Syntax By Yuli Vasiliev Back to Oracle Database 9i, the OUTER JOIN syntax was introduced to provide the ANSI-standard alternative to proprietary outer join operator (+). However, some people still don’t want to switch. This article provides an example that illustrates how the OUTER JOIN syntax compares favorably with the (+) operator. To walk […]

Continue Reading →
Pro Members SQL Server Standard Members

Types of Join in SQL Server – (Part 1)

by

Types of Join in SQL Server – Part 1 Author: Basit A. Farooq In this two part article series, I will discuss different types of joins available in SQL Server. You use a join to combine data from different tables into a single result set. Joins most commonly use foreign key relationships. Some important points about joins include: Joins are...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →