create table t1 ( val1 varchar(10) primary key, val2 varchar(10) ) create table t2 ( tmp1 varchar(10) primary key, tmp2 varchar(10) )