Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cshah1
Constraint Violating Yak Guru
347 Posts |
 Posted - 2010-09-07 : 22:00:59
|
| tableA and tableBIf left join is performed likeSELECT *FROM tableA LEFT OUTER JOIN tableB ON tableA.ID = tableB.ID(select * is bad but used for brevity)I am familiar with preserved and non-preserved table, so in abovetableB is calld non-preserved table and tableA is preserved table.however, I am not familiar with some terminologywhich table is called "outer table"? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-09-07 : 22:46:35
|
quote:
Inner and outer tablesThe terms outer table and inner table describe the placement of the tables in an outer join: * In a left join, the outer table and inner table are the left and right tables respectively. The outer table and inner table are also referred to as the row-preserving and null-supplying tables, respectively. * In a right join, the outer table and inner table are the right and left tables respectively. For example, in the queries below, T1 is the outer table and T2 is the inner table:T1 left join T2T2 right join T1
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/12016;pt=11971
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Outer table in LEFT JOIN