Pregunta de entrevista de Dun & Bradstreet

How would you handle an SQL join today?