How do you get all records from 2 tables. Which join do you use?
- 8 Answers
- 17776 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / kavithanedigunta
full outer join in 10 g
select a.*,d.dname
from emp a
full outer join
dept d on
a.DEPTNO = d.DEPTNO
full outer join in 9i
select a.* ,d.DNAME
from emp a, dept d
where a.DEPTNO = d.DEPTNO
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is the functionality of the function htmlentities? : Sql dba
How do sql triggers work?
How do you select unique values in sql?
How to run pl sql program in mysql?
Is progress software supports to ( pl/sql )?
Can you have a foreign key without a primary key?
What is set transaction?
Where is pl sql used?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Does sql*plus have a pl/sql engine?
how to drop an existing index in mysql? : Sql dba
What are the differences between implicit and explicit cursors?
Differentiate pl/sql and sql?
Which is faster count (*) or count 1?
Can we create a trigger on view?
