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
Is coalesce faster than isnull?
what is sub-query? : Transact sql
How do I make my sql query run faster?
What is a primary key sql?
What is join view in sql?
what is sql? : Sql dba
How to select random rows from a table?
what is a materialized view? : Sql dba
Explain some predefined exceptions.
What does the file extension accdb stand for?
how can we destroy the cookie? : Sql dba
What is nvarchar max in sql?
How many triggers can be applied to a table?
how to rename an existing column in a table? : Sql dba
Why do we use procedures?