How do you get all records from 2 tables. Which join do you use?
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
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is an invalid partition table?
What is the process of copying data from table a to table b?
What are the sql aggregate functions?
Is sql easier than java?
what are the advantages of using stored procedures? : Sql dba
Why do we create views in sql?
How to pronounce postgresql?
How do you write a subquery?
What is parameter substitution in sql?
Why does sql need a server?
How sql query is executed?
How do you use a while loop in pl sql?
How do you run a query?
Do ddl statements need commit?