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 shortcut join?could give any one example?

Answer Posted / rajasekhar

hi,
The joins are two types... the first one is equi-join that
is using of = symbol.for example we have two tables called
wmp and dept. in emp we have deptno object. the same object
we have dept table also then we can create like this:
emp.deptno = dept.deptno.
The non-equijoin is with out same object from the both table
by using between keyword. we can take the bellow example
like emp(empno,sal) and salgrade(grade, lesssal,highsal) we
can create join from the aboue table like this: where sal
between lesssal and highsal.

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2037


Explain what task is 98% of the required work of a business analyst?

1075


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

997


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1088


Explain is data mart?

998


Explain the data types present in bo and what happens if we implement view in the designer and report?

1000


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

977


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1026


how to create reports on screech?

2538


How to execute the plsql procedure from the report by clicking with mouse?

1116


What is the difference in creating filters in designer and business objects?

1011


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1132


What are all difference between business objects 6.5 and xi r2?

1016


What task is 98% of the required work of a business analyst?

1029


Can anybody tell me what are the tuning problems?

2033