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 do I find duplicates in a single column in sql?
What is data manipulation language?
Explain the the delete statements in sql?
what is not null constraint? : Sql dba
What are the properties of a transaction?
What is the need of a partition key?
how does a local variable is defined using t-sql? : Transact sql
What is indexing oracle sql?
What is an exception in pl/sql?
how to calculate the difference between two dates? : Sql dba
Which are the different character-manipulation functions in sql?
Which are the different types of indexes in sql?
Explain what is sql*plus?
explain the delete statements in sql
Can dml statements be used in pl/sql?