How do you get all records from 2 tables. Which join do you use?
Answer Posted / pervez
using full outer join or Cartesian join we can get all records
from two tables
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How to get help at the sql prompt?
Can %notfound return null after a fetch?
What is a full join?
What are the 3 types of behavioral triggers?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is data profiling in sql?
What are the two types of periodical indexes?
How do I view a table in sql?
What is difference between ms sql and mysql?
Is t sql a programming language?
what is a trigger in mysql? : Sql dba
what does it mean to have quoted_identifier on? : Sql dba
Why is there a need for sqlcode and sqlerrm variables?
Why do we use sql constraints?
How do we use distinct statement? What is its use?