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
- 19217 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / gvmahesh
full outer join.
select ename,sal,dname,loc,e.deptno from emp e
full outer join dept d on e.deptno=d.deptno;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Why is sql better than hql?
Can I create table without primary key?
Could you please provide oca (oracle 10g) dumps for my certification ?
what is offset-fetch filter in tsql? : Transact sql
What are the different parts of a package?
What is function and procedure in pl sql?
What is procedure function?
What is a data definition language?
What are tables in sql?
What is auto increment in sql?
explain the difference between bool, tinyint and bit. : Sql dba
Which command is used to delete a trigger?
what is 'mysqldump'? : Sql dba
What do you think about pl/sql?
