What is meant by Join? What are the different types of
Joins available? Explain.
Answer Posted / kilari hemadri
Joins is used to relate two tables and display the result..
types of joins are
inner join
left join
right join
full join
cross join
inner join : It is used to display the common values in
both the tables based on the condition given.
left join : Left join displays all the contents of left
table and dislays the right table contents that are present
in left table.
right join : it is contraversy to left join
full join : it is combination of both left and right joins.
cross join: it takes one row of left table and matches with
all the rows in the right table.
Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
How to avoid duplicate records in a query?
What is blind sql injection?
How exception is different from error?
what is not null constraint? : Sql dba
how would you get the current date in mysql? : Sql dba
What is the difference between execution of triggers and stored procedures?
Describe sql comments?
How to know the last executed procedure?
What type of database is cloud sql?
what are the differences between binary and varbinary? : Sql dba
Can a trigger call a stored procedure?
How can you save or place your msg in a table?
what are properties of a transaction? : Sql dba
What is the difference between a subquery and a join?
what is data integrity? : Sql dba