What are JOINS and how to use them?

The JOIN keyword is used in a MySQL statement to query data from two or more tables...

How to combine result with UNION operator?

In order to combine two or more result sets into one, and thus increase readability and speed up querying, the UNION operator may be used. Syntax The basic syntax...

Matching rows from different tables with INNER JOIN clause

The INNER JOIN clause let us match rows with same columns from two different tables. Following rules have to be applied to use the INNER JOIN clause: It mus...

Matching data from different database tables with LEFT JOIN (RIGHT JOIN) clause

The LEFT JOIN clause allows us to match...

Creating Table where table joins itself with Self JOIN

The SELF-JOIN is relationship where the match fields are in same table. Here a table is joined with itself when table has a

UPDATE a database with values of another database by JOIN Clause

To change data of an already created table UPDATE is used. The UPDATE statement

DELETE Statements and JOIN clause

In some situations, where the data to be deleted are known only after combining databases with ...

What is ON DELETE CASCADE?

When user wants to delete data from child tables, whenever the data is deleted from parent table, on