What is join view in sql?



What is join view in sql?..

Answer / Santosh Kumar Mishra

A Join View in SQL combines two or more tables, views, or query results based on a specified join condition. It allows you to create temporary virtual tables for use in the execution of a SELECT statement.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are few of the schema objects that are created using PL/SQL?

1 Answers  


How to select all records from the table?

1 Answers  


If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,


What is pivot query?

1 Answers  


Explain two virtual tables available at the time of database trigger execution.

1 Answers  


what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,


Do you know the basic structure of PL/SQL?

3 Answers  


Define overloaded procedure?

1 Answers  


What are schema-level triggers?

1 Answers  


how to enter characters as hex numbers? : Sql dba

1 Answers  


what is bdb (berkeleydb)? : Sql dba

1 Answers  


explain primary keys and auto increment fields in mysql : sql dba

1 Answers  


Categories