This particular query does a nested loop on the detail table, but basically yes. Only one iteration.