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
- 19291 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
What is %s in sql?
Is sql a microsoft product?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is substitution variable?
What type of join is sql join?
Does truncate table reset auto increment?
Can we rollback delete command?
How do I save a stored procedure?
What is posting?
Why is stored procedure faster than query?
Why are sql stored procedures used?
What is the difference between null value, zero, and blank space?
how can we know the number of days between two given dates using mysql? : Sql dba
What is package in pl sql with an examples?
Is ms sql traffic encrypted?
