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 is difference between inner join and self join?
How do you write a subquery?
Is join an inner join?
How do I upgrade sql?
How to return multiple records from procedure?
discuss about myisam key cache. : Sql dba
Can primary key be changed?
how to connect oracle in unix prompt?
When is a declare statement required?
How can we find duplicate records in a table?
what tools available for managing mysql server? : Sql dba
how mysql optimizes distinct? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)