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

Why would we populate bu_id, while importing product or account data?

856


Explain what is client business service?

998


What are the steps required to set the policy expression?

905


Explain how is siebel 7.x data model is different from siebel 6.0 data model?

978


What is siebel?

1004


Explain when do we go for dynamic picklist and for pick applet?

926


How would you find entity relation in siebel tools?

963


What are the different screens available in Siebel?

2184


What is the difference between an organization and division in Siebel?

1020


what is the link specification?

1015


Explain what is eapps.cfg file?

980


How to find out new vanilla functionality in SIEBEL 7.7 and 7.8?

5325


How do you handle error handling in wfs?

1116


Explain how to do validations in escripts and in configuration?

966


I have created hierarchical picklist. In parent all the values are displayed. When the values selected in the parent its displays proper value in the child picklist?

1133