TOP CATEGORIES

×

What is SQL joins?

S

Sravani

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

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

Email: advertise@gdatamart.com

Donate: To Support US

© 2024 GDATAMART.COM (All Rights Reserved)