MySQL Relationships (JOIN explained)

The visual diagrams still confuse me after so many years and I always forget…so here it is:

INNER JOIN gets all records from one table that have some related entry in a second table

LEFT JOIN gets all records from the LEFT linked table but if you have selected some columns from the RIGHT table, if there is no related records, these columns will contain NULL

RIGHT JOIN is like the above but gets all records in the RIGHT table

FULL JOIN gets all records from both tables and puts NULL in the columns where related records do not exist in the opposite table

2 Responses to MySQL Relationships (JOIN explained)

  1. eddie007 says:

    If you are a user of Windows 10 operating system here with the help of our article, you will set the alarm set in a few steps in your Windows 10 PC, most users set windows 10 alarm so that they can get their work done on time .

  2. PaulBlake says:

    A relationship is one-to-numerous if one item in Table can apply to different things in Table. The terms female and male will apply to many people, however each person can be only one or the other. A one-to-numerous relationship is the most well-known one between tables in databases. dissertation writing uk | DissertationTime

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Anti-Spam Quiz: