Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Different Types of Joins and How do They Work?
- 1 Answers
- 1793 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
Using an inner join, records from both tables with matching values are retrieved.
All records from the left table and matched records from the right table are retrieved using a left join, also known as a left outer join. Records from the right table that don't match will be NULL.
All records from the right table and matched records from the left table are retrieved using a right join, also known as a right outer join. Records from the left table that don't match will be NULL.
When there is a match in either the left or right table, records are retrieved using a full join (full outer join). Records from both tables that don't match will be NULL.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is package in dbms?
Explain concurrency transparency.
How many number of columns can a RECORD GROUP have ?
Can group by and ordered by used in a single query?
What is the example of rdbms?
What is 3nf in the dbms?
Why does reading require write privileges on database file?
What exactly is a database?
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
What are the functions of rdbms?
What's the best database software for mac?
Why is database used?
What are the properties of a database?
What are the different types of keys in the database?
what are the different integrity rules present in the dbms?
