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

what are the basic features of seu?

819


What is the difference between crtdupobj and copyf?

948


how can a message from a message file appear as a constant on the screen?

1270


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

1348


what is arrival sequence?

1500


what is the command to know key fields of file?

876


Hello, I have created a CMD type object. In one of the fields in Display file , I would like to see All the Source files present by pass the name of Library. Tried using CHoice(Keyword) and Choicepgm on PARM , but doesn't seems to be working. Any help please..

2039


The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

2129


what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.

6448


what is xfoot opcode ?

1405


when should I use method get, and when should I use method post in my cgis?

866


what are the different methods to access seu?

847


which of the cl command can be used to determine which logical files are dependent on a specific file?

823


what are the limitations of cl (compare to rpg) ?

1949


how you get the relative record in a subfile in which cursor is located?

862