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

What is trigger and how to use it in sql?

1021

What are keys in sql?

1000

what is 'mysqlcheck'? : Sql dba

1016

What is union?

1170

How do you modify a column in sql?

999

What is clustered index sql?

985

How do I find sql profiler?

944

How to rename a column in the output of sql query?

1072

Explain cursor types?

1030

Are stored procedures faster than queries?

948

What port does sql server use?

1063

What is number function in sql?

975

What is pivot table in sql?

1108

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

What is package in pl sql with an examples?

1036