Database System ConceptsIntended for a first course in databases at junior or senior undergraduate, or first year graduate level, this work provides extensive coverage of concepts, database system internals and tools and techniques. |
From inside the book
Results 1-3 of 41
Page 109
... outer join . The right outer join ( ) is symmetric with the left outer join : It pads tuples from the right relation that did not match any from the left relation with nulls and adds them to the result of the natural join . In Figure ...
... outer join . The right outer join ( ) is symmetric with the left outer join : It pads tuples from the right relation that did not match any from the left relation with nulls and adds them to the result of the natural join . In Figure ...
Page 166
Abraham Silberschatz, Henry F. Korth, S. Sudarshan. Join types inner join left outer join right outer join full outer join Join Conditions natural on < predicate > using ( A1 , A1 , ...... . , An ) ... Figure 4.5 Join types and join ...
Abraham Silberschatz, Henry F. Korth, S. Sudarshan. Join types inner join left outer join right outer join full outer join Join Conditions natural on < predicate > using ( A1 , A1 , ...... . , An ) ... Figure 4.5 Join types and join ...
Page 516
... Join Recall the outer - join operations described in Section 3.3.3 . For example , the natural left outer join customer depositor contains the join of customer ... outer joins and outer joins with an equi - 516 Query Processing Chapter 13.
... Join Recall the outer - join operations described in Section 3.3.3 . For example , the natural left outer join customer depositor contains the join of customer ... outer joins and outer joins with an equi - 516 Query Processing Chapter 13.
Other editions - View all
Common terms and phrases
account number account-number aggregate algorithm amount application assets B+-tree balance bank BCNF block borrower branch-city branch-name Brooklyn bucket candidate key Chapter clause compute consider contains customer-city customer-name customer-street data model database design database system Datalog decomposition defined definition delete depositor disk domain domain relational calculus Downtown E-R diagram E-R model employee example expression Figure foreign key functional dependencies hash identifier implementation insert interface JDBC Jones loan number loan-number manager multivalued dependencies node normal form null values object object-oriented ODBC ODMG operation outer join Perryridge branch persistent pointers primary key programming language query Find query language r₁ records recursive relation schema relational algebra relational calculus relational database relational-algebra relationship set result search-key value Section select customer-name specify storage stored structure subquery superkey t₁ trigger tuple relational calculus tuples update variable view relation weak entity weak entity set write