full outer join syntax

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Collation Sensitivity ? What are the various type ?

493


Why is partition used in sql?

541


List and explain the different types of join clauses supported in ansi-standard sql?

807


What is pls_integer in pl sql?

534


How do I enable sql encryption?

516






What is a primary key? Explain

536


Explain what is sql?

602


How do sql triggers work?

546


Enlist the characteristics of pl/sql?

1235


Why indexing is needed?

511


How do I view stored procedures?

534


What is the difference between mdf and ndf files?

558


What is difference sql and mysql?

527


Why is sql better than hql?

500


Does view contain data?

610