How do you get all records from 2 tables. Which join do you use?
- 8 Answers
- 16882 Views
- Microsoft, I also Faced
- E-Mail Answers
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
What is sql key?
What is pragma in sql?
What are sql functions? Describe the different types of sql functions?
How to get unique records from a table?
What are all the common sql functions?
What is spool?
What is triggering circuit?
What is the difference between delete and truncate statement in sql?
Which tcp/ip port does sql server run?
What is the function that is used to transfer a pl/sql table log to a database table?
What is out parameter used for eventhough return statement can also be used in pl/sql?
How do I count records in sql?
How to know the last executed procedure?
What is a recursive join sql?
How do you define a foreign key?
