Скачать или смотреть Cross Join in MySQL || MySQL Tutorial || Code With Neha

In my previous video of mysql series I have discussed about right join in mysql
You can check the video from the above I button
Today I am going to discuss about what is cross join in mysql with example so without any further delay let's get started


What is Cross Join?

A CROSS JOIN, also known as a Cartesian Join, is a type of join that returns the Cartesian product of the two joined tables. This means that each row from the first table is combined with every row from the second table. If the first table has m rows and the second table has n rows, the result set will have m×n rows.


the Cartesian product of two sets A and B, denoted A × B, is the set of all ordered pairs (a, b) where a is an element of A and b is an element of B

The CROSS JOIN keyword returns all matching records from both tables whether the other table matches or not. So, if there are rows in "Customers" that do not have matches in "Orders", or if there are rows in "Orders" that do not have matches in "Customers", those rows will be listed as well.

If you add a WHERE clause (if table1 and table2 has a relationship), the CROSS JOIN will produce the same result as the INNER JOIN clause:


that's all for today Hope you all will get some help from this video
If it's so then don't forget to subscribe my channel Code with Neha and press the Bell Icon for Regular Updates
See you in the next video till then Stay Safe Stay Happy
#crossjoininMySQL
#crossjoininsql
#crossjoininmysql
#crossjoininsql
#joinsindbms
#joininmysql
#joinsexample
#mysqlcrossjoin
#sqlcrossjoin
#mysql
#mysqldatabase
#mysqltutorial
#sqljoins
#mysqltutorialforbeginners
#mysqldb
#mysqltutorials
#SQLJOINS
#JoinsinSQL
#SQLJoinsTutorial
#SQLJOINSTutorialforbeginners
#SQLJOINQuerieswithExamples
#introductiontojoininsql
#Joininmysql
#sqljoins
#sqltypesofjoins
#sqljoinstutorialforbeginners
#sqljoinswithexample
#sqljoinsexamples
#SQLqueriesusingJoins
#SQLJoinqueries
#joins
#joinsindbms
#typesofjoinsindbms
#needofjoins
#joinsexample
#joinvssubquery
#typesofjoins