Bank of America Interview Question

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