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

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

1990


Give some information on report bursting?

979


any difficulitis have you phase while creating bo reports and how did u solve it

3432


What is a bo repository?

1034


in sap bi we have wad, then why we go for sap bo

3367


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3453


Can anybody tell me what are the tuning problems?

2033


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2253


Explain in detail about type 2(scd),

1084


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1011


How can you first report in Business Objects by using broadcast agent?

3038


What is difference between webi and infoview?

1228


Which versions are used in the bo dashboard work?

1035


What is a fantrap in business objects?

1161


Explain what are the steps to do to use alerts in bo?

1068