What Is Complex Join? Difference With Foreign Key Primary Key Join?

1.	What Is Complex Join? Difference With Foreign Key Primary Key Join?
Answer» COMPLEX joins are joins which have following diffrences from a PK-FK joins # Complex joins can have conditional MAPPINGS like >,&LT;,>=,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 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.

Answer»

COMPLEX joins are joins which have following diffrences from a PK-FK joins

# Complex joins can have conditional MAPPINGS like >,&LT;,>=,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 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.

Discussion

No Comment Found

Related InterviewSolutions

What Happens If You Create An Employee In Siebel Application And Forget To Create?
What Does Position Represents In Siebel?
What Are The Different Types Of Columns?
How Do You Recognize That A Particular Table (base Table ) Can Be Extended?
When Do We Go For Bc Level User Properties?
How Do You Import List Of Values?
What Is The Difference Between Eim And Eai?
How Do You Set Up Employees In Siebel?
What Are Pre Defined Queries?
What Is The Difference Between "picklist Generic" And "picklist Hierarchical" Business Components?