Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How to avoid using indicators in ile ?

1268


what is the purpose of putovr (put with explicit override) keyword?

1646


How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?

1261


during input operation which indicator position is seton if there is a record lock?

1590


what is the maximum number of record formats in dspf?

1682


what is subfile?

1585


how many specifications are there in rpg/400? What are they?

2002


What is access path in as400?

1348


I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.

2737


what is a composite key?

1670


if we tried to move year part of *iso date into a field of length 3, what will happen ?

1284


What is file access opcodes?

1354


what are the uses of factor1, factor2 and result field for the rpg operation code parm?

1036


what is the difference between normal upddta to pf and updating using dfu program?

1338


what is the purpose of ovrdta and ovrata keywords ?

1503