Anand Singhania

• Feb 10th, 2006

 

Hi,

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

regards

anand

Zakeer Hussain

• Mar 31st, 2006

 

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

Foregin Key:- by using the forgin key we can define the joins between two tables. joins between is 1:M or M:M. if we want to define many:many relationship we have to use bridge tables.

lgpati

• Apr 10th, 2006

 

Hi Anand,

Thanks for relpy.

you mentioned that  PK-FK is always 1-N and  complex joins can have (1-0,1) and (0,1-N).

as per my knowledge i understand that 1-N is one -- many relation .

can you tell me what is these relationships (1-0,1) and (0,1-N)

Thanks..

1-N), whereas complex joins can have (1 - 0,1) and (0,1 - N) kind of relationships

suchi

• Apr 14th, 2006

 

Can any body tell me..how to configure the complex join?

sreenathg

• May 31st, 2007

 

I think complex join is that join within join where as two tables doesn't have any foreign key means at that time complex join is used