A SELF JOIN is a join that is used to join a table with itself. However, there is a need to combine data with other data in the same table itself. In that case, we use Self... READ MORE >>
Cross JOIN is a simplest form of JOINs which matches each row from one database table to all rows of another. In other words, it gives us combinations of each row of first table with all records in second table. Syntax SELECT... READ MORE >>
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 >>
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 >>
Recent Comments