retrieve into temp (t1.all, ounique1=o.unique1,ounique2=o.unique2,otwo=o.two,ofour=o.four,oten=o.ten,otwenty= o.twenty, ohundred=o.hundred,othousand=o.thousand,otwothousand=o.twothousand,ofivethous=o.fivethous,otenthous=o.tenthous,oodd=o.odd, oeven=o.even,ostringu1=o.stringu1,ostringu2=o.stringu2,ostring4=o.string4 ) from o in onek, t1 in tenk1, t2 in tenk2 where (o.unique1 = t1.unique1) and (t1.unique1 = t2.unique1) and (t1.unique1 < 1000) and (t2.unique1 < 1000)
destroy temp
retrieve into temp (t1.all, ounique1=o.unique1,ounique2=o.unique2,otwo=o.two,ofour=o.four,oten=o.ten,otwenty= o.twenty, ohundred=o.hundred,othousand=o.thousand,otwothousand=o.twothousand,ofivethous=o.fivethous,otenthous=o.tenthous,oodd=o.odd, oeven=o.even,ostringu1=o.stringu1,ostringu2=o.stringu2,ostring4=o.string4 ) from o in onek, t1 in tenk1, t2 in tenk2 where (o.unique1 = t1.unique1) and (t1.unique1 = t2.unique1) and (t1.unique1 < 1000) and (t2.unique1 < 1000)