What does an outer join do?

Answer Posted / guest

Includes unmatched rows from both tables. If any column of
the result table does not have a value, that column has the
null value in the result table.

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many databases are there?

808


Why do we use cursor?

843


How to create backup table in db2?

869


What is deadlock in db2?

836


How to restart a DB2 program?

1627


My sql statement select avg(salary) from emp yields inaccurate results. Why?

873


How to find schema of a table in db2?

778


What is bufferpool in db2?

825


How to execute stored procedures?

877


What is dbrm?

882


Mention the different locking levels that are available in db2.

889


What is dbrm? When it will be created?

794


Is db2 relational database?

772


What are the benefits of using the db2 database?

908


How to test SQL -911 error while developing COB-DB2 program

7128