What is JOIN and different types of JOIN.

Answer Posted / vamsikrishnamraju

Sometimes we have to select data from two or more tables to
make our result complete.
inner join
left join
right join

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are catalog tables in db2?

601


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7479


What is precompiler in db2?

582


What is copy pending and check pending in db2?

570


What is the difference between using bind () and rebind () methods of naming class?

782






How to rename a table in DB2 ?

630


What is cloudant database?

638


What is a buffer in memory?

589


When the like statement is used?

627


How is the value function used?

598


What are bind parameters in db2?

607


What is the information associated with sysibm.syslinks table?

651


What is bind package and plan in db2?

591


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1795


Which are the db2 tools to protect integrity of the database?

681