What are Joins

0 votes
Hi!!

Can someone tell me what Joins are?
Dec 14, 2018 in Database by Sahiti
• 6,370 points
334 views

1 answer to this question.

0 votes

JOINS are used to combine rows from two or more tables, based on a related column between those tables. The following are the types of joins: 

  • INNER JOIN: This join returns those records which have matching values in both the tables.
  • FULL JOIN: This join returns all those records which either have a match in the left or the right table.
  • LEFT JOIN: This join returns records from the left table, and also those records which satisfy the condition from the right table.
  • RIGHT JOIN: This join returns records from the right table, and also those records which satisfy the condition from the left table.
answered Dec 14, 2018 by DataKing99
• 8,240 points

Related Questions In Database

0 votes
1 answer

What are stored procedures?

The stored procedure is a collection of ...READ MORE

answered Aug 23, 2018 in Database by CodingByHeart77
• 3,740 points
1,069 views
0 votes
1 answer

What are stored procedures in database?

A stored procedure is a collection of ...READ MORE

answered Sep 6, 2018 in Database by CodingByHeart77
• 3,740 points
912 views
0 votes
2 answers

What are the ways to get the count of records in a table

With the help of the SQL count ...READ MORE

answered Aug 20, 2020 in Database by Okugbe
• 280 points
3,574 views
0 votes
1 answer

What are the different types of index?

There are three types of index namely: Unique ...READ MORE

answered Oct 17, 2018 in Database by Sahiti
• 6,370 points
7,919 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
908 views
0 votes
1 answer

Find values in a comma separated string in a MySQL query

You can add commas to the left and ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,370 points
12,632 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,370 points
2,032 views
0 votes
1 answer
0 votes
1 answer

What are the manipulation functions in SQL?

There are three case manipulation functions in ...READ MORE

answered Oct 11, 2018 in Database by DataKing99
• 8,240 points
4,952 views
0 votes
1 answer

What are the various levels of constraints

Constraints are the representation of a column ...READ MORE

answered Oct 18, 2018 in Database by DataKing99
• 8,240 points
2,553 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP