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

Answer Posted / vinay

use full outer join you can get the records

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is subquery? : Sql dba

773


Explain about various levels of constraint.

700


what are the authentication modes in sql server? How can it be changed? : Sql dba

954


Why do we need view in sql?

730


What is use of term?

794






how many columns can be used for creating index? : Sql dba

673


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

728


What is normalization in sql?

718


Is natural join same as inner join?

677


Does truncate need commit?

698


How many triggers can be applied to a table?

779


What is a Mapplet?

824


What is pragma in pl sql?

766


What are procedures used for?

700


Who developed sql?

756