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 pl sql and why it is used for?

1070

What normalization means?

905

How do you delete duplicates in sql query using rowid?

892

What is %type in pl sql?

924

what is an index? : Sql dba

930

What are the dml statements?

1095

What is a dynamic query?

971

What does dml mean?

928

what is normalization? : Sql dba

1015

How do I view output in sql developer?

1027

Is sql workbench free?

930

How do I save a sql query?

961

what is subquery? : Sql dba

1066

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1035

What is pl/sql table? Why it is used?

989