Unit Price In this example we are combining two concepts to show that more than two tables can be JOINed in one SELECT statement and more than one JOIN type can be used in a single SELECT statement.

Sales Territory table, NULL values are returned for the columns in the Sales. In addition, this code uses two columns to order the data i.e.

) Thanks, Dick How do I INSERT or UPDATE an array of values without iteration?

In SQL Server you can do this using UPDATE statement by joining tables together.In a nutshell, joins are typically performed in the FROM clause of a table or view for the SELECT, INSERT... syntax, but the support has been reduced and the best practice in SQL Server is to use the syntax outlined in the examples below. Before we jump into code, let's provide some baseline information on the joins options in SQL Server: Let's walk through examples from the Adventure Works sample database that is available for SQL Server to provide examples of each type of join then provide some insight into the usage and sample result sets. As you can see the JOIN order and tables are different, but the final result set matches the LEFT OUTER JOIN logic. In fact, I struggled with this problem for quite some time before I found out about this gem.