MySQL 7 kinds of joins

One

Select *  from Inner Join  on A.key= B.Key

Two

Select *  from  Left Join  on A.key= B.Key

Three

Select *  from  Right Join  on A.key= B.Key

Four

Select *  from  Left Join  on A.key= B.keywhere B.keyisnull

Five

Select *  from  Right Join  on A.key= B.keywhere A.keyisnull

Six

Select *  from  Left Join  on A.key= B.KeyUnionSelect*from right  Join on A.key= B.Key

Seven

Select *  fromA Left JoinB onA.Key =B.Key whereB.Key  is NULLUnionSelect *  fromA Right JoinB onA.Key =B.Key whereA.Key  is NULL

MySQL 7 kinds of joins