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

How does index help in query performance?

1087

What is a composite primary key?

1142

what is log shipping? : Sql dba

1163

What is primary key secondary key alternate key candidate key?

1085

How do you drop a trigger?

1035

what is a control file ? : Sql dba

1085

What is multiple columns?

1114

What is the difference between local variables and global variables?

1173

What is dml and ddl?

1008

what is a constraint? Tell me about its various levels. : Sql dba

1043

How do you declare a variable in pl sql?

1067

Explain sql data types?

1143

What is union, minus and interact commands?

1361

what are all the common sql function? : Sql dba

1102

Explain the difference between triggers and constraints?

1023