Explicitly specifying the join condition - SQL

SELECT *

FROM IS_CALLED JOIN IS_ENROLLED_ON

ON ( IS_CALLED.StudentId = IS_ENROLLED_ON.StudentId )

Now, the key word JOIN in all of the foregoing examples can be harmlessly preceded by the word INNER. SQL also supports what are called "outer joins". The outer join of t1 and t2 contains all the rows of the inner join and possibly some more if either operand has rows which fail to participate in the inner join. Such a row might participate in the outer join, accompanied by NULL for each column of the other operand. The key words LEFT, RIGHT, and FULL, each optionally followed by OUTER, are used to specify whether unmatched rows of the first (left) operand, the second (right) operand, or both operands, respectively, are to appear in the result. Example shows an SQL outer join. A single row for student S5 appears in the result, with NULL in place of a value for CourseId.

Posted Date: 1/18/2013 4:51:22 AM | Location : United States

Ask an Expert

Related Discussions:- Explicitly specifying the join condition - sql, Assignment Help, Ask Question on Explicitly specifying the join condition - sql, Get Answer, Expert's Help, Explicitly specifying the join condition - sql Discussions

Write discussion on Explicitly specifying the join condition - sql
Your posts are moderated

Write your message here..

Related Questions

Currval and nextval - sql pseudocolumns, CURRVAL and NEXTVAL The serie... CURRVAL and NEXTVAL The series is a schema object which generates the sequential numbers. Whenever you form a sequence, you can specify its primary value and an increment. T

Loop statements, LOOP Statements The LOOP statements execute a series o... LOOP Statements The LOOP statements execute a series of statements at multiple times. The loops enclose the series of statements that is to be repeated. The PL/SQL provides typ

Error handling in pl/sql, Error Handling The PL/SQL makes it easy to de... Error Handling The PL/SQL makes it easy to detect and process the predefined and user-defined error conditions known as exceptions. Whenever an error occurs, an exception is ra

Parameter and keyword description - update statement, Parameter and Keyword... Parameter and Keyword Description:   table_reference: This keyword identifies the table or view that should be accessible when you execute the UPDATE statement, and for wh

Control structure, Control Structures The Control structures are the mo... Control Structures The Control structures are the most important PL/SQL extension to the SQL. Not only does PL/SQL let you manipulate Oracle data, it lets you process the data

Using cursor attributes - bulk bind performance improvement, Using Cursor A... Using Cursor Attributes To process the SQL data manipulation statements, the SQL engine must opens an implicit cursor named SQL. This cursor's attributes (%FOUND, %NOTFOUND, %

Using commit, Using COMMIT The COMMIT statements end the present trans... Using COMMIT The COMMIT statements end the present transaction and make permanent any changes made during that transaction. Till you commit the changes, other users cannot acc

Extension and and in sql, Extension and AND in SQL The theory book giv... Extension and AND in SQL The theory book gives the following simple example of relational extension in Tutorial D: EXTEND IS_CALLED ADD ( FirstLetter ( Name ) AS Initial )

Methods in pl/sql, Methods: In normal, a method is a subprogram declar... Methods: In normal, a method is a subprogram declared in an object type specification using the keyword MEMBER or STATIC. The method cannot have similar name as the object typ

Data types in sql, Data Types in SQL SQL's concept does not differ sig... Data Types in SQL SQL's concept does not differ significantly from that defined in the theory book, apart from that business concerning NULL. However, the theory book equates