Неверное заполнение dataTable

OleDbCommand oleDbFlats = new OleDbCommand(sqlFlats, GetDbConnection());
OleDbDataAdapter daFlats = new OleDbDataAdapter(oleDbFlats);
daFlats.Fill(dtFlats);

select 
  (t4.name||', '||t3.name||', '||t2.name||', '||t1.name||', '||u.name) Flat,
  c.lastname||' '||c.firstname||' '||c.secondname FSL,
  c.docnum Docnum,
  dataPred.Stamp StampPred,
  dataPred.Val ValPred,
  dataPred.znach relPred,
  dataCur.stamp StampCur,
  dataCur.val ValCur,
  dataCur.znach relCur,
  (dataCur.Val-dataPred.Val) Volume,
  ch.sernum Sernum,ch.idinc Idinc,
  m.title mtrName,
  (m.intdig + m.decimal) digit
from c 
     join 
         (select t.* from t where t.id = 163 and t.type = 6 
                 union 
         (select t.* from table(log(163))t where t.type = 6))u on 
         u.id = c.id 
     join ch on 
          ch.dc = c.dc and 
          ch.ob = c.ob and 
          ch.d = c.d and 
          ch.j = c.j and 
          ch.ch = c.ch and 
          ch.mn = 0 and ch.mki = 1
     join m on
          m.mtr = ch.mtr 
     left join dat dataCur on 
          dataCur.dc = ch.dc and 
          dataCur.ob = ch.ob and 
          dataCur.d = ch.d and 
          dataCur.j = ch.j and 
          dataCur.ch = ch.ch and 
          dataCur.stamp = to_date('01.11.2011','dd.mm.yyyy') and 
          dataCur.znach = 3 and dataCur.Tarid = 0
     left join dat dataPred on 
          dataPred.dc = ch.dc and 
          dataPred.ob = ch.ob and 
          dataPred.d = ch.d and 
          dataPred.j = ch.j and 
          dataPred.ch = ch.ch and 
          dataPred.stamp = to_date('01.10.2011','dd.mm.yyyy') and 
          dataPred.znach = 3 and dataPred.Tarid = 0
     join t t1 on 
          t1.id = u.idp 
             join t t2 on 
                  t2.id = t1.idp 
                     join t t3 on 
                          t3.id = t2.idp 
                             join t t4 on 
                                  t4.id = t3.idp 
                                     join t t5 on 
                                          t5.id = t4.idp

OleDbCommand oleDbFlats = new OleDbCommand(sqlFlats, GetDbConnection());
OleDbDataAdapter daFlats = new OleDbDataAdapter(oleDbFlats);
daFlats.Fill(dtFlats);