Explain an outer join ?
An outer join includes rows from tables when there are no matching values in the tables.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is implied Join. Where do we find it ? 03.11.08
Join between two Tables. Join Object defines The Relationship Between a Bc and atable.Join allows Bc to get Column from table rather then basetable. I...What difference between join specification , join definition, join criteria and link specification? 26.09.08
Let us write SQL query to understand this: select s.name,a.name (1) from s_evt_act a,...Compare a subselect to a join ? 03.04.08
Any subselect can be rewritten as a join, but not vice versa. Joins are usually more efficient as join rows can be returned immediately, subselects require a...DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences? 03.04.08
A merge join requires that the tables being joined be in a sequence; the rows are retrieved with a high cluster ratio index or are sorted by DB2. A nested joi...What is an inner join, and an outer join ? 20.03.08
Inner Join: combine information from two or more tables by comparing all values that meet the search criteria in the designated column or columns of one table w...What are the different types of joins? 16.11.06
Different Types of Joins- Inner Join Outer Join - Right Outer Join & Left Outer Join Cross Join...What is a self join? 06.08.06
Self join is just like any other join, except that two instances of the same table will be joined in the query....What is a join and explain different types of joins. 06.08.06
Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table. Ty...What is a OUTER JOIN ? 16.03.06
Outer Join--Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join cond...What is 5NF? 11.03.06
A Relation schema R is said to be 5NF if for every join dependency {R1, R2, ..., Rn} that holds R, one the following is true Ri = R for some i.The join depen...