Pergunta de entrevista da empresa GOLDPoint Systems

Given 2 small SQL tables, write a simple JOIN statement to get certain rows from each table