The same way other databases do it. With join mechanics and proper query planning. You're confusing functionality with implementation.