Interested to Buy Any Domain ? << Click Here >> for more details...
How do you get all records from 2 tables. Which join do you use?
- 8 Answers
- 19515 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
Explain two easy sql optimizations.
What is sap sql anywhere?
what is unique key constraint? : Sql dba
difference between anonymous blocks and sub-programs.
what is primary key? : Sql dba
what are myisam tables? : Sql dba
What are the different dcl commands in sql?
Where can I learn sql for free?
What do you mean by table in sql?
How do I make my sql query run faster?
what is the difference between undefined value and null value? : Sql dba
What is having clause in sql?
What if we write return in procedure?
What are string functions in sql?
Does view store data in sql?
