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...

please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.

Answer Posted / punnaiahbabu

Equi join means equlity condition b/w tables
left outerjoin :matching and unmatching from left side onley
matched from right side.........
right outer join:matching and unmatching from right side
onley matched from left side.
outer join :matching and unmatching displed both of the tables
self join:we will right on sql query on the 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 create Index to the table in the universe designer and how it improves the Query performence

2498


Explain how many universes can be created in a project?

1007


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

997


Did you face any problems while creating reports? Name? Solutions?

3639


how get the grand total in master-detail report?

2172


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4357


Explain what sort of existing documents should business analysts refer to when starting on a new project?

947


What is package in BO

3146


what is universe null

2364


8. How much supervision have you typically received in your previous job?

2201


Can more than 1 metric be applied on an analytic in business objects?

2096


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1949


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2390


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1826


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4252