SQL Functions and Table Joins Class 12 Notes

CBSE Notes for SQL Functions and Table Joins Class 12 Notes

SQL stands for Structured Query Language. It is mainly used for data manipulation, data modification, and data retrieval. This comes around with the Relational Database Management System (RDBMS).A simple join means is to combine two or more tables in a given database. A join works on a common entity of two tables.

An inner join is used to select records that contain common or matching values in both the tables (TableA and Table B). Non-matching are eliminated. So, let's understand the type of joins, and with common examples and the differences between them. Please refer SQL Functions and Table Joins Class 12 Notes for more information.