How to Create a Self-Contained Scalar Subquery in SQL Server

In this tutorial you will learn what a self-contained scalar subquery is and how to create one. A scalar subquery is a subquery that returns a single value regardless if it is self-contained.
Category: MYSQL | View Tutorial

Views: 9

How to Outer Join Tables in SQL Server

This tutorial will show you how to use the outer joins on tables. Outer joins make use of the JOIN keyword between the table names to let SQL Server know to mark a table as “preserved”. There are three different types of outer joins: LEFT, RIGHT, and FULL. The LEFT keyword means that the rows of the left table are preserved, the RIGHT keyword means that the rows int he right table are preserved, and the FULL keyword means that the rows in both the left and right tables are preserved.
Category: MYSQL | View Tutorial

Views: 4