Pergunta de entrevista da empresa Caterpillar

In the context of relational databases, explain what a join is.