What are Joins?

0 votes
Hi!!

Can someone tell me what Joins are?
Dec 14, 2018 in Database by darklord
• 6,140 points
38 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,100 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,680 points
100 views
0 votes
1 answer

What are stored procedures in database?

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

answered Sep 5, 2018 in Database by CodingByHeart77
• 3,680 points
61 views
0 votes
1 answer

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

To count the number of records in ...READ MORE

answered Sep 26, 2018 in Database by darklord
• 6,140 points
50 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 darklord
• 6,140 points
70 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,100 points
35 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 darklord
• 6,140 points
1,280 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 darklord
• 6,140 points
143 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,100 points
387 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,100 points
75 views