DO THIS !

SQL Server WHERE clause example uses the WHERE clause to join multiple tables together in a single SELECT statement. This SELECT statement would return all rows where the first_name in the employees table is 'Sarah'. And the employees and contacts tables are joined on the employee_id from the employees table and the contact_id from the contacts table.

DO THIS !

SQL Server WHERE clause example uses the WHERE clause to join multiple tables together in a single SELECT statement. This SELECT statement would return all rows where the first_name in the employees table is 'Sarah'. And the employees and contacts tables are joined on the employee_id from the employees table and the contact_id from the contacts table.

Example - Joining Tables

Let's look at how to use the WHERE clause when we join multiple tables together.

For example:

SELECT employees.employee_id, contacts.last_name
FROM employees
INNER JOIN contacts
ON employees.employee_id = contacts.contact_id
WHERE employees.first_name = 'Sarah';

This SQL Server WHERE clause example uses the WHERE clause to join multiple tables together in a single SELECT statement. This SELECT statement would return all rows where the first_name in the employees table is 'Sarah'. And the employees and contacts tables are joined on the employee_id from the employees table and the contact_id from the contacts table.