Prior to the introduction of the JOIN Keyword the implicit join was widely used, so you need to be familiar with it
What Happened to the Klingons?
Bad Database Design in the lifeforms table
There is no JOIN Keyword here
The WHERE is performing the JOIN