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

When do we use genbscript.exe?

972


How would you import international phone numbers using eim in siebel realtime?

929


When do you use property sets in siebel?

1251


How to improve your performance in views?

910


What difference between join specification and join definition?

964


Tell me when do you use property sets in siebel?

926


Explain in brief about siebmtsh.exe.

924


what is seibel admin mode view? How to create one?

863


What is the purpose of 1:m extended table?

987


What are the different views available in Siebel?

2114


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

838


whats the difference between siebel 7.5 and 7.8?

987


How would you remove unnecessary seed data by deleting all rows from the s_lst_of_val base table?

960


Explain where you will drop the constraints?

958


What is the differences between static and dynamic drilldowns?

956