How do you get all records from 2 tables. Which join do you use?

Answer Posted / rao

Using FULLOUTER JOIN

Is This Answer Correct ?    25 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

545


how to fetch common records from two tables? : Sql dba

633


How long it takes to learn pl sql?

534


What are sql built in functions?

512


What is pl sql in dbms?

508






How can we avoid duplicating records in a query?

568


Why is sql better than hql?

510


What is difference between sql and oracle?

568


Is vs as in pl sql?

494


What are views in sql?

547


how to include numeric values in sql statements? : Sql dba

565


What is sqlerrm?

553


Why do we need a foreign key?

553


How is a process of pl/sql compiled?

602


How do you update a sql procedure?

527