Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / avi007
full outer join -
select * from table1,table2 where
table1.columnname(+)=table2.colunmname;
union
select * from table1,table2 where
table1.columnname =table2.colunmname(+);
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is data profiling in sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What are the different ddl commands in sql?
what is self-join? : Sql dba
What is difference sql and mysql?
What is sql and explain its components?
What are the advantages of normalization?
How run sql*plus commands that are stored in a local file?
Which join is like an inner join?
What is synonyms?
How do you modify a column in sql?
How do I run a pl sql program?
What is normalization sql?
How do I trace sql profiler?
What is set transaction?
