#database join

The SQL JOIN Clause is used to combine records from one or more tables on a database.A JOIN is a method of combining fields from two tables using common values ​​in each. Example let look at the following two tables Table 1 – Students ID Name Adress 1 Krishna Rathore India 2 Tom Germany 3 Tony Us 4 Gajanand India 5 Henry Canada Table 2 –…

The join operation is used to combine related tuples from two relations. This operation is very important in relational databases because it allows to process relationship among relations.

The join operation is the combination of the product, selection and projection operations. The join operation on two relations is performed as follows:

Product operation is performed on two relations.

Selection (SELECT) operation is performed to eliminate duplicate tuples by the join criteria or condition.

Projection (PROJECT) operation is performed to remove some attributes.

The PROJECT operation is another unary operation. This operation returns a set of tuples containing a subset of the attributes in the original relation. Thus, as we state that the SELECT operation selects some rows and discards the others. The PROJECT operation, on the other hand, selects some columns of the relation and discards the other column. The PROJECT operation can be viewed as the vertical filter of the relation.