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
What is union and union all keyword in sql and what are their differences?
Can we rename a column in the output of sql query?
Why do we use sqlite?
Explain about various levels of constraint.
What is left join in sql?
What are the three forms of normalization?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is a heap in sql?
What is the difference between numeric and autonumber?
What is the use of sql trace?
What are the ddl commands?
What is file based approach?
What is the difference between the implicit and explicit cursors?
how to enter binary numbers in sql statements? : Sql dba
what is a field in a database ? : Sql dba