[ice]

пример:

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