CREATE TABLE CombineDie1Die2 AS SELECT WL, BL, Die1, Die_2 as Die2 FROM Die1_10k a, Die2_10k b WHERE a.WL = b.WL AND a.BL = b.BL