using full outer join or Cartesian join we can get all records from two ta

How do you get all records from 2 tables. Which join do you use?

Question Posted / pervez

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

Please Help Members By Posting Answers For Below Questions

Explain the the delete statements in sql?

581

what are the 'mysql' command line arguments? : Sql dba

654

Can you do multiple joins in sql?

550

How can we optimize a sql query?

580

What are %type and %rowtype for?

619

What is data control language?

532

What's the procedure?

492

Is it possible to sort a column using a column alias?

609

What are the advantages of stored procedure?

544

What is sql entity?

534

what is a foreign key ? : Sql dba

611

What is difference between sql and mysql?

537

What is compiled query?

522

What is the starting oracle error number? What is meant by forward declaration in functions?

544

What is pivot in sql?

514