If you want a one-row-one-row combination you could use a cursor on each table and walk through the rows spitting out a new row with all of the relevant fields from each table. You could also do a row_number() on each set and join on that to get a one-to-one matchup. This is much better because not only is it not RBAR it also gives you at least some control about how to order the numbering.