What are joins..how many types of joins are there?
Answer Posted / neet verma
A JOIN is a means for combining fields from two tables by
using values common to each.
there are three types of joins:-
1)inner join
a)eqi join
b)natural join
c)cross join
2)outer join
a)Left outer join
b)Right outer joins
c)Full outer join
3) self join
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
How do I uninstall oracle 11g?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Can we save images in a database and if yes, how?
What is set operator oracle?
What privilege is needed for a user to create tables in oracle?
What are the predefined tablespaces in a database?
Explain oracle insert into command?
6. Display the client name and order date for all orders using the traditional method.
List out the components of logical database structure of oracle database.
Explain table?
Is the After report trigger fired if the report execution fails ?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Explain what are the type of synonyms?
Explain how are indexes update?
Explain the types of exception?