while select mytable join myTable2 where myTable2.id == mytable.Id { myTmpTable.clear(); myTmpTable.Value = mytable.Value; myTmpTable.Value2 = mytable2.Value2; myTmpTable.insert(); }