This was the realisation that made me finally understand joins (although they're certainly not generally implemented like that in practice!).