Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 96977 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / john
Depending on condition existence
----CROSS JOIN (synonyms also CARTESIAN JOIN, CARTESIAN PRODUCT)
----NATURAL JOIN
----# NAMED COLUMNS JOIN - syntactic notation joining source
tables on user defined columns having the same name. This is
less dangerous than Natural join and just short form of
writing Equi joins on some common columns joined together.
Named columns joins always are Equi joins.
----# CONDITIONAL JOIN - fully controllable syntax by user.
This is the most widespread and most useful syntactic
convention. Depending on used predicates in join condition
it may be Equi join as well as Non-equi join.
Depending on row selection
INNER JOIN
OUTER JOIN--- left,right,full
Depending on comparison operator
equi Non-equi
Depending on used tables
SELF JOIN
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is pragma autonomous transaction in oracle?
WHAT IS ecc 6.0
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to connect to the server with user account: sys?
What is materialized view in Oracle?
Explain constraining triggers.
Explain an extent?
What are the general rules on data consistency?
What is system tablespace?
What is bind variable in oracle 11g?
What are named parameters?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Explain rename?
What is a synonym? What are its various types?
