select * from table full outer join tablename2; or select * from tab

full outer join syntax

Question Posted / naresh

Answer Posted / naresh

select * from table full outer join tablename2;

or

select * from table1,table2 where
table1.columnname(+)=table2.colunmname(+);

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

how to select first 5 records from a table? : Sql dba

1021

what are ddl statements in mysql? : Sql dba

1261

Can a procedure in a package be overloaded?

1097

How to run sql statements with oracle sql developer?

1118

How does cross join work?

1006

What is sap sql?

1028

Explain clause in sql?

1070

How to load data with sql*loader?

1110

What is sql and db2?

1050

How many primary keys can a table have?

1052

What is %s in sql?

1075

Explain what is sql*plus?

1194

What does trigger mean in psychology?

1008

State few characteristics of pl/sql?

1019

What does the argument [or replace] do?

1125