What is meant by Join? What are the different types of
Joins available? Explain.
Answer Posted / mahesh
joins are used to relate two tables and display the result..
Types of join
1.inner join
2.outer join
2.1 left outer join
2.2 right outer join
2.3 full outre join
3.cross join
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
how to fetch common records from two tables? : Sql dba
What are %type and %rowtype for?
What is the difference between stored procedure and view?
How do I write a cron which will run a sql query and mail the results to agroup?
What is data control language (dcl)?
What are the two virtual tables available at the time of database trigger execution?
What is a composite primary key?
What is coalesce in sql?
what is sql server agent? : Sql dba
Mention what does plv msg allows you to do?
What is the meaning of disabling a trigger?
What is the starting oracle error number?
What are three advantages to using sql?
What does count (*) mean in sql?
What is normalisation and its types?