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

What is 19 null in sql?

532


What is a schema sql?

529


What is the mutating table and constraining table?

554


Does execute immediate commit?

695


Lookups are a key component in sql server integration services (ssis). Explain its purpose?

535






Why use truncate instead of delete?

542


How to connect a sql*plus session to an oracle server?

619


What is query syntax?

519


explain commit and rollback in mysql : sql dba

544


What are character functions?

628


What language is oracle sql developer?

508


How to read xml file in oracle pl sql?

502


What are two statement types in sql?

536


What does pl sql stand for?

652


What is cross join example?

549