Types of joins ?
Answers were Sorted based on User's Feedback
Answer / ramesh yadav
IN ORACLE 9i.
Equi - Join = Both are same Names only different
simple join
inner join
Natural join
join
Non - Equi Join
Outer Join
Left outer join
Right outer joi
Full outer join
Self join
Cartesian Product
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / bipin
sql-server
inner join
outer join
left outer join
right outer join
full outer join
cross join
oracle sql
inner join
outer join
left outer join
right outer join
full outer join
cross join
natural join
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / vinodkumar.r
2 types
1)inner join ,
2)outer join
a)left outer
b)right outer
c)full outer
Is This Answer Correct ? | 7 Yes | 2 No |
What are all the different normalization?
what are date and time functions in mysql? : Sql dba
What is embedded sql in db2?
Which sorts rows in sql?
What are actual parameters and formal parameters?
Is record in oracle pl sql?
how to calcuate the second highest salary of he employee
What are the types of optimization?
what is the difference between implicit conversions and explicit conversions?
how to enter numeric values as hex numbers? : Sql dba
How do I run a query in pl sql developer?
what are different types of keys in sql?