sql2sgd('select a.ls,h.street, h.name, a.num,a.owner,p.ob,p.pay,p.nb,p.date,p.coment, h.num  from pay p left join apart a on p.apart=a.id left join house h on a.house =h.id where a.ls like ''%'
          + edt1.Text +
          '%''and h.street like ''%' + edt2.Text +
          '%''and h.num like ''%' + edt3.Text +
          '%'' and h.name like ''%' + edt4.Text +
          '%'' and a.num like''%' + edt5.text +
          '%''and a.owner like ''%' + edt6.text +
          '%'' and p.ob like ''%' + edt7.text +
           //'%'' and p.pay like''%' + edt8.text + 
          // '%'' and p.nb like ''%' + edt9.text + 
         '%'' and p.date like''%' + edt10.text +
          '%'' and p.coment like''%' + edt11.text + '%'';');

select a.ls,h.street, h.name, a.num,a.owner,p.ob,p.pay,p.nb,p.date,p.coment, h.num  from 
pay p left join apart a on p.apart=a.id 
left join house h on a.house =h.id 
where a.ls like '%%'
and h.street like '%%'
and h.num like '%%' 
and h.name like '%%' 
and a.num like'%%'
and a.owner like '%%'
and p.ob like '%%'
and p.pay like'%%'
and p.nb like '%%'
and p.date like'%%'
 and p.coment like'%%';

CREATE TABLE apart (lgota TEXT, lifespace NUMERIC, privat TEXT, ls TEXT, balance NUMERIC, residents NUMERIC, house NUMERIC, id INTEGER PRIMARY KEY, num TEXT, owner TEXT, space NUMERIC);
CREATE TABLE house (apart NUMERIC, id INTEGER PRIMARY KEY, kp TEXT, name TEXT, num TEXT, street TEXT);
CREATE TABLE pay (ob TEXT, nb TEXT, apart TEXT, coment TEXT, date TEXT, id INTEGER PRIMARY KEY, pay NUMERIC);
CREATE TABLE residents (unprop TEXT, prop TEXT, rodstv TEXT, incode TEXT, passport TEXT, apart TEXT, f TEXT, i TEXT, id INTEGER PRIMARY KEY, o TEXT, year TEXT);