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 complex join?

Answer Posted / edin

Complex joins are joins which have following diffrences
from a PK-FK joins???.
Complex joins can have conditional mappings like
>,<,>=,NOT,AND,etc apart from '=' whereas the PK-FK joins
are always '='

PK-FK joins are always (1-N), whereas complex joins can
have (1 - 0,1) and (0,1 - N) kind of relationships.

Complex join:- complex join are used in physical layer in
between two tables where ever that do not involved primary
key and foreign key relationship.

Is This Answer Correct ?    19 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is if table in eim?

1015


Explain where you will drop the constraints?

1019


What is the procedure to configure the static caching using the content group?

1087


How we will create drilldown in form applet?

1102


What is the use of the indirect multivalue link and how do you configure it?

1048


Explain why do we need to create employees at the database in siebel?

1018


in a three level hierarchial picklist say country,state,city how do we perform pickmap 2)say if we have values same for country (having value 'A') and for state (having value 'A') and for city having value 'B' and in parent Lic we give value for city as 'A' how do it recognise it as State any other solution

3056


Name the databases you have worked on?

1030


How to assign responsibilities to employees in siebel?

933


How do you invoke wfs?

1123


what is the difference between "picklist generic" and "picklist hierarchical" business components?

1028


Suppose if a view has admin mode property = true, then what will happen to user properties we write on them?

895


what is the difference between join and link?

1205


Explain what is the difference between links and multi value links?

989


Explain the netscalar one-arm mode deployment model.

998