I want to know the basic difference between them.
Enter your MySQL question at the top of this page and click Get An Answer.
Tell us how quickly you want your MySQL question answered.
Connect with your programmer via online chat or telephone call.
I want to know the basic difference between them.
The main difference is in the way tables are joined if there are no common records.
If we reverse the order of tables in a Left or Right Join we achieve the results of Right and Left Join.
That is, a left join b is similar to b right join a.
The LEFT JOIN operator includes all records from the left of the operator; the RIGHT JOIN operator
includes all records to the right of the operator.
Thank you.
Byron Narciso
Programmer
Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.
ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!