[MySQL] Talk about Join method in SQL

---

Today We gotta go study about join. I think if you used this first time It will be difficult a little bit. because this method need to understand about relationship. If you are study about join, you can understand easily. So Let's go follow me .

---

 

Create table book5

 

Create table review5

 

 

Insert into book5 values

 

Insert into review5 values 

 

 

left join

 

 

What's different with inner join? 

left

 

inner

 

※As you can see It 's different whether there is a NULL or not.

---

 

 

To be continue