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

Answer Posted / sri

UNION ALL

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is input buffer in sql*plus?

638


What is the difference between count 1 and count (*) in a sql query?

497


How do I upgrade sql?

544


How many parts of a pl sql block are optional?

515


Can two tables have same primary key?

531






Compare sql & pl/sql

605


What is sqlerrm?

542


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

528


What are inner and outer joins examples of both?

494


What is %type in sql?

510


What are the popular database management systems in the it industry?

561


How do you bind variables in pl sql?

578


How do I find duplicates in the same column?

541


What is the difference between jpql and sql?

551


how many triggers are allowed in mysql table? : Sql dba

556