Topics

×

Search Question

What is SQL joins?

By: Sami Khan | 02 July 2019

S

Sravani

06 July 2019

By using joins ,you can retrieve the data from two are more tables based on the logical relationship between the tables in Ms SQL server

1 votes

H

HARSHIT SINGH

11 January 2020

There are Four Joins used in SQL Database

When joining two tables in SQL Join, then Make sure that the column name of both tables is the same otherwise It is not possible to join two tables with SQL Join; Types of SQL Join with Small descriptions:

  • Full Join - Retrieve all the records from two are more tables
  • Left SQL Joining OR Left Outer Join - Retrieve all the records from the left table BUT on common records from the right table & The outer join ignores the common records from both tables.
  • Right SQL Joining OR Right Outer Join - Retrieve all the records from the right table BUT on common records from the left table.
  • Inner Join - Retrieve all the records, which one common both the table.

0 votes

Your Answer

Policy

GDATAMART.COM is optimized for learning & job information; The users try to improve your knowledge and practical experience through this site but we cannot warrant full correctness of all content... Learn More →

© 2020 GDATAMART | All Rights Reserved