Full joins are used to combine rows from two or more tables based on a related column between them.

Jacob's joins are located all over the city.

Right outer joins are used to combine records from two tables based on matching values in a specified column.

Left outer joins are used to combine records from two tables based on a common column.

Full outer joins are used to combine the results of both left and right outer joins.

He joins the choir invisible.

Join the club!

I will join up the two pieces of the puzzle.

She is joining up with her friends for a road trip.

Her joined up handwriting is beautiful.