MySQL RIGHT JOIN

RIGHT JOIN returns all the rows from the right table even if no matching rows have been found in the left table. Its returned null if no row matches the condition on left table. Syntax SELECT column_list FROM table_1 RIGHT JOIN...
READ MORE   >>

MySQL LEFT OUTER JOIN

LEFT JOIN returns all the rows from the left table even if no matching rows have been found in the right table. Its returned null if no row matches the condition on right table. Syntax SELECT column_list FROM table_1 LEFT JOIN table_2...
READ MORE   >>

MySQL INNER/ SIMPLE JOIN

INNER JOIN returns rows from both tables that satisfy with given conditions. Syntax SELECT column_list FROM table_1 INNER JOIN table_2 ON join_condition; Example SELECT r.rollno, r.name, f.fees, f.status FROM register...
READ MORE   >>

Joins in MySQL

JOINS are used to retrieve data from multiple tables. It is performed whenever you need to fetch records from one (Self Join), two or more tables based on the common column between the tables and tables are mutually related using primary and...
READ MORE   >>