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 |
What are pre defined queries?
How to create a Primary foriegn key because there is no PFK in account for Opprtunity ,it is 1:M relationship
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
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?
What is the procedure to configure the static caching using the content group?
Why is it not recommended to modify existing base tables?
What is the difference between the MVG applet and List applet? What is the relationship they have?
What is the "parent category" property for a screen view?
what is the difference between 1:1 and 1:M extension tables ?
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)
When do you use genbscript.exe?
How to create an extension table with an intersection table?