Select database queries with Inner, Left and Right Join represent an important part of SQL syntax and come in very handy when you want to make more advanced queries.
Remember the legendary Predator movie with Arnold Schwarzenegger? Those Predator aliens had this thermal view feature so they could their prey even in complete darkness, let's Photoshop it.