What does an outer join do?



What does an outer join do?..

Answer / 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

More DB2 Interview Questions

How to create db2 table in mainframe?

0 Answers  


what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,


Which is faster delete or truncate?

0 Answers  


what is the process of precompiler?

2 Answers  


what is sql abend code -801,-802?

2 Answers  






How can you compare table column after update and before update?

5 Answers   Satyam,


What is DCLGEN?

2 Answers  


where can we use index and subscript ? with example ?

3 Answers   CTS,


Define db2.

0 Answers  


What is a synonym ?

2 Answers  


Explain about open switch business continuity software?

0 Answers  


what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,


Categories