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

Is coalesce faster than isnull?

502


what is sub-query? : Transact sql

596


How do I make my sql query run faster?

466


What is a primary key sql?

559


What is join view in sql?

510






what is sql? : Sql dba

557


How to select random rows from a table?

518


what is a materialized view? : Sql dba

571


Explain some predefined exceptions.

582


What does the file extension accdb stand for?

545


how can we destroy the cookie? : Sql dba

555


What is nvarchar max in sql?

578


How many triggers can be applied to a table?

596


how to rename an existing column in a table? : Sql dba

509


Why do we use procedures?

510