Using FULLOUTER JOIN

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

Question Posted / rao

Answer Posted / rao

Is This Answer Correct ?

25 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain what is rdbms?

1028

Which constraints we can use while creating database in sql?

1075

How many times can we commit in a loop?

1013

what are the t string functions available in tsql? : Transact sql

1002

How can we optimize a sql query?

1045

What is the difference between null value, zero, and blank space?

1197

What is left join in sql?

1043

What is a unique key?

1050

how to create a new view in mysql? : Sql dba

930

What does seeding a database mean?

952

Is grant a ddl statement?

894

How do you define a foreign key?

994

what is the difference between a local and a global temporary table? : Sql dba

1070

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1146

What is type and rowtype in pl sql?

1012