SQL is a special-purpose programming language designed for managing information in a relational database management system (RDBMS). The word relational here is key; it specifies that the database management system is organised in such a way that there are clear relations defined between different sets of data. Join makes relational database systems relational. Joins allow you to link data from two or more tables together into a single query result--from one single SELECT statement. .When combining rows from multiple tables in one query, you need to use the JOIN command. There are a few different types of joins, and the following should help explain the differences between them. The syntax will vary depending on which database type you are using. In this course i have used Oracle database. The JOIN operations, which are among the possible Table Expressions in a FROM clause, perform joins between two tables.