What is full join?



What is full join?..

Answer / Faeem Akhter

A FULL JOIN (or CARTESIAN JOIN) combines all records from both tables, regardless of whether they have a match. If there are no matches, NULL values will be returned for the columns of the missing table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is rtm stands for?

1 Answers  


How does postgresql compare to mysql?

1 Answers  


What is the cause of mutating table error and how can we solve it?

1 Answers  


Can we insert data into materialized view?

1 Answers  


what is the purpose of update command in oracle?

7 Answers   MBT,


Show the two pl/sql cursor exceptions.

1 Answers  


Can dml statements be used in pl/sql?

1 Answers  


How can we overcome recursive triggers in SQL?

1 Answers   iFlex,


What is transaction control language (tcl)?

1 Answers  


what is the difference between trigger and constraint?

3 Answers   HSBC,


What are the parts of a sql statement?

1 Answers  


How can we implement rollback or commit statement in a trigger?

1 Answers  


Categories