Skip to content

Joins in MySQL

Below are some of SQL join Queries:

  1. Select * from TableA A left join TableB B on A.key = B.key
  2. Select * from TableA A left join TableB B on A.key = B.key where B.key is null
  3. Select * from TableA A full outer join TableB B on A.key = B.key
  4. Select * from TableA A inner join TableB B on A.key = B.key
  5. Select * from TableA A right join TableB B on A.key = B.key
  6. Select * from TableA A right join TableB B on A.key = B.key where A.key is null
  7. Select * from TableA A full outer join TableB B on A.key = B.key where A.key is null or B.key is null

Published inSQL

Be First to Comment

Leave a Reply

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