Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Outer joins [Table of Contents] Outer
join restrictions

Transact-SQL User's Guide

[-] Chapter 4 Joins: Retrieving Data from Several Tables
[-] Outer joins
[-] Inner and outer tables

Inner and outer tables

The terms outer table and inner table describe the placement of the tables in an outer join:

For example, in the queries below, T1 is the outer table and T2 is the inner table:

T1 left join T2
T2 right join T1

Or, using Transact-SQL syntax:

T1 *= T2
T2 =* T1


Outer joins [Table of Contents] Outer
join restrictions