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

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

981


What is universal database?

831


What is the connection string to connect to the DB2 Database ?

856


What is host variable?

808


How to view db2 table structure?

800


Explain the contention situations caused by locks?

800


Explain about dbrm.

786


What is the information associated with sysibm.syslinks table?

880


what is diffrence b/w file-aid tool and file-aid utility???

4530


How can you count the number of rows from a table tab?

840


Define predicate?

861


What is node in db2?

812


What is the function of logging in the db2 database?

862


Mention data types used in db2 ?

883


Explain the benefits you can get from mainframe connect?

732