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

Can you skip header records while loading? : aql loader

542


What is prepared statement in sql?

543


What are predefined functions in sql?

531


How to use sql*plus built-in timers?

576


What is clustered index in sql?

584






What is rowid in sql?

508


What is informix sql?

535


Can we use joins in subquery?

531


Which normal form is best?

513


Explain cursor types?

578


Can function return multiple values in sql?

526


What does subquery mean in sql?

538


Explain what is dbms?

577


What is sharding in sql?

564


How do I know if I have sql express or standard?

597