What is left outer join?

Answer Posted / syam

This is using in SQL
A left outer join will return all the rows that an inner
join returns plus one row for each of the other rows in the
first table that did not have a match in the second table.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

when are the unique constraints executed?

680


what are the different types of data areas?

982


maximum number of subfiles that can be active for a single file is?

974


How to reverse a string using RPG?

689


Can we debug the MSGW JOBS?

927






define what a data queue is along with a brief example of what it may be used for?

1065


why is as/400 called object oriented machine?

949


what is a program described file in rpg?

1050


using dfu, user will be able to ___________ from physical file?

577


how many printer files maximum can be used in single rpg program?

675


How Many Specs Are There In Rpg & Which Are They?

682


when would you use or not use this approach?

888


Write a logic program for knowing the repeated number of a vowels in a given program?

3307


Can any one explain the basic things about RLU and Printer Files and their Definitions for both and why are they used,i'm a newbee so please help me out

2901


what is scan and xlate?

1087