select table1.columnname1,table2.columnname2 from table1 full outer join

full outer join syntax

Question Posted / thiyagarajan

Answer Posted / thiyagarajan

select table1.columnname1,table2.columnname2
from
table1 full outer join table2
on
table1.colname=table2.colname

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is cursor status?

1187

What is a mutating table and a constraining table?

1115

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1050

What is a full join?

991

What is Histogram?

1559

What is offset and limit in sql?

1058

What is the size of partition table?

1048

How to call shell script from pl sql procedure?

1281

what is the difference between union and union all? : Sql dba

1020

What are conditional predicates?

1062

What is the most restrictive isolation level? : Transact sql

1085

What are dml commands?

1020

What is the difference between function and procedure in pl/sql?

1086

What is sql query limit?

980

Is ms sql traffic encrypted?

925