simple cartesian join with a wrapping select criteria? select distinct * from ( select a.key, a.var1, a.var2... b.key as b.key_, b.var1, b.var2 from table1 a, table2 b ) where (a.key = b.key_); provided you have enough space/memory/ etc. to do this all in one step? or maybe it's not this simple?
... View more