What is a join?



What is a join?..

Answer / Satish Chadhary

A join in SQL is a process of combining two or more tables based on a common column between them, known as the join key. Joins help retrieve and link data from multiple tables to answer complex questions about the relationship between the data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

why use cursors?

5 Answers   Oracle,


What is triggering circuit?

1 Answers  


how can i create a user defined datatype

3 Answers  


Can we rollback delete command?

1 Answers  


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

5 Answers  


What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,


Is ms sql is free?

1 Answers  


What packages are available to pl/sql developers?

1 Answers  


Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,


Is primary key a clustered index?

1 Answers  


how to shut down the server with 'mysqladmin'? : Sql dba

1 Answers  


How exception is different from error?

1 Answers  


Categories