Question d’entretien chez Bank of America

which approach has a performance advantage: table-join or sub-select?