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?



What is complex join?..

Answer / 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

More Siebel Interview Questions

What are pre defined queries?

0 Answers  


How to create a Primary foriegn key because there is no PFK in account for Opprtunity ,it is 1:M relationship

2 Answers  


In link if we set Link Specification as "True" then what will be the expression given for link specification to access parent bc field value in child bc

5 Answers   IBM,


what is the difference between siebel 7.5 and 7.8? If we upgrade the application to 7.8 from 7.5 what are the areas we need to give importance from qa(testing) point of view?

0 Answers  


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

0 Answers  


Why is it not recommended to modify existing base tables?

1 Answers   Siebel Systems,


What is the difference between the MVG applet and List applet? What is the relationship they have?

1 Answers   IBM,


What is the "parent category" property for a screen view?

0 Answers  


what is the difference between 1:1 and 1:M extension tables ?

4 Answers  


how to create constain picklist?process suppose country field is there and state field is there,when user selected Australia in country,i have to display aus related states only states field? pls senme ans to (selvarajb.tech@gmail.com)

3 Answers   Logica CMG, Satyam,


When do you use genbscript.exe?

0 Answers  


How to create an extension table with an intersection table?

0 Answers  


Categories