select full_name as полное_наименование, short_name as сокращённое_наименование,
acc as счёт, cst.codeokpo as ОКПО,
ad.address as адрес,
txr.dt_reg as дата_регистрации, name_sti as орган_регистрации, num_reg as номер_регистрации,
phone as телефон, fax as факс, email,
jhis.desctext as история, typename, sprk.remark as Уровень_риска_проведения_легализации_доходов,
ac.idcustomer
from customer cst, account ac, address ad, tax_registration txr, spr_reg spr,
 contact cnt, jurhistory jhis, jurdesctype jdesc, risk rk, spr_risk_kod sprk
where acc='2600......'

and cst.idcustomer=ac.idcustomer
and cst.idcustomer=ad.idcustomer
and cst.idcustomer=txr.idcustomer
and txr.c_dst=spr.c_dst
and cst.idcustomer=cnt.idcustomer
and cst.idcustomer=jhis.idcustomer
and jhis.desctype=jdesc.desctype
and rk.risk_kod=sprk.risk_kod

select full_name, short_name, acc, desctext
from vaccount a, customer c LEFT OUTER JOIN jurhistory j on c.idcustomer=j.idcustomer

where acc='39007910001'
and c.idcustomer=a.idcustomer
and c.idcustomer=j.idcustomer

select full_name as полное_наименование, short_name as сокращённое_наименование,
acc as счёт, cst.codeokpo as ОКПО,
ad.address as адрес,
txr.dt_reg as дата_регистрации, name_sti as орган_регистрации, num_reg as номер_регистрации,
phone as телефон, fax as факс, email,
jhis.desctext as история, typename, sprk.remark as Уровень_риска_проведения_легализации_доходов,
ac.idcustomer
from customer cst, vaccount ac, address ad, tax_registration txr, spr_reg spr, contact cnt, jurhistory jhis, jurdesctype jdesc, risk rk, spr_risk_kod sprk

where substr(acc,  1 , 4 ) in ('2600')

and cst.idcustomer=ac.idcustomer
and cst.idcustomer=ad.idcustomer
and cst.idcustomer=txr.idcustomer
and txr.c_dst=spr.c_dst
and cst.idcustomer=cnt.idcustomer
and cst.idcustomer=jhis.idcustomer
and jhis.desctype=jdesc.desctype
and rk.risk_kod=sprk.risk_kod

select full_name as полное_наименование, short_name as сокращённое_наименование,

acc as счёт, cst.codeokpo as ОКПО,

ad.address as адрес,

txr.dt_reg as дата_регистрации, name_sti as орган_регистрации, num_reg as номер_регистрации,

phone as телефон, fax as факс, email,

jhis.desctext as история, typename, sprk.remark as Уровень_риска_проведения_легализации_доходов,

ac.idcustomer

from customer cst left outer join jurhistory jhis on cst.idcustomer=jhis.idcustomer, vaccount ac, address ad, tax_registration txr, spr_reg spr, contact cnt, jurdesctype jdesc, risk rk, spr_risk_kod sprk

where acc='39007910001'

and cst.idcustomer=ac.idcustomer
and cst.idcustomer=ad.idcustomer
and cst.idcustomer=txr.idcustomer
and txr.c_dst=spr.c_dst
and cst.idcustomer=cnt.idcustomer
and cst.idcustomer=jhis.idcustomer
and jhis.desctype=jdesc.desctype
--and jhis.desctext is not null
and rk.risk_kod=sprk.risk_kod

select
distinct (full_name), short_name,
acc, c.codeokpo,
address,
dt_reg,
desctext

from vaccount a, address ad, tax_registration t, customer c LEFT OUTER JOIN jurhistory j on c.idcustomer=j.idcustomer

where acc='39007910001'
and c.idcustomer=a.idcustomer
and c.idcustomer=ad.idcustomer
and c.idcustomer=t.idcustomer

select
distinct (full_name), short_name,
acc, codeokpo,
address,
t.c_dst, dt_reg, name_sti, num_reg,
j.desctype, typename, desctext

from vaccount a, address ad, tax_registration t, customer c, OUTER jurhistory j, spr_reg sp, jurdesctype jd
where acc='39007910001'
and c.idcustomer=j.idcustomer
and c.idcustomer=a.idcustomer
and c.idcustomer=ad.idcustomer
and c.idcustomer=t.idcustomer
and t.c_dst=sp.c_dst
and jd.desctype=j.desctype

select
distinct (full_name), short_name,
acc, codeokpo,
address,
j.desctype, desctext,

(select  typename from customer c, jurdesctype jd, vaccount a, jurhistory j
where acc='2600215937001'
and c.idcustomer=a.idcustomer
and c.idcustomer=j.idcustomer
and j.desctype=jd.desctype) îïèñàíèå_þðèñòîðèè,

(select t.c_reg from customer c, vaccount a, outer tax_registration t, spr_reg sp
where acc='2600215937001'
and c.idcustomer=a.idcustomer
and t.c_dst=sp.c_dst
and c.idcustomer=t.idcustomer)


from vaccount a, address ad, tax_registration t, customer c, OUTER jurhistory j, spr_reg sp, jurdesctype jd
where acc='2600215937001'

and jd.desctype=j.desctype
and j.idcustomer=c.idcustomer
and c.idcustomer=a.idcustomer
and c.idcustomer=ad.idcustomer
and sp.c_dst=t.c_dst
and c.idcustomer=t.idcustomer

select
distinct (full_name), short_name,
acc, codeokpo,
address,
j.desctype, desctext,


(select  typename from customer c, jurdesctype jd, vaccount a, jurhistory j
where acc='2600215937001'
and c.idcustomer=a.idcustomer
and c.idcustomer=j.idcustomer
and j.desctype=jd.desctype) описание_юристории,


(select num_reg from vaccount v, outer tax_registration tr
where acc='2600215937001'
and v.idcustomer=tr.idcustomer) номер_регистрации,


(select dt_reg from vaccount v, outer tax_registration tr
where acc='2600215937001'
and v.idcustomer=tr.idcustomer) дата_регистрации,


(select name_sti from vaccount a, spr_reg sp, tax_registration t
where acc='2600501191001'
and a.idcustomer=t.idcustomer
and sp.status='0'
and sp.c_dst=t.c_dst)

from vaccount a, address ad, customer c, OUTER jurhistory j
where acc='2600215937001'

and j.idcustomer=c.idcustomer
and c.idcustomer=a.idcustomer
and c.idcustomer=ad.idcustomer

select
distinct (full_name), short_name,
acc, codeokpo,
address, phone, fax, email,

(select  desctext from customer c, jurdesctype jd, vaccount a, jurhistory j
where acc='2600701223001'
and c.idcustomer=a.idcustomer
and c.idcustomer=j.idcustomer
and j.desctype=jd.desctype
and j.desctype='305') репутация,

num_reg, dt_reg,

(select risk_kod from risk r, vaccount a
where acc='2600701223001'
and a.idcustomer=r.idcustomer) as risk_kod,

(select remark from spr_risk_kod srk, risk r, vaccount a
where acc='2600701223001'
and a.idcustomer=r.idcustomer
and r.risk_kod=srk.risk_kod) Риск_легализации_доходов,

clt.link_type, clt.remark, surname, name, midname,  {прив персоны}

(select  desctext from customer c, jurdesctype jd, vaccount a, jurhistory j
where acc='2600701223001'
and c.idcustomer=a.idcustomer
and c.idcustomer=j.idcustomer
and j.desctype=jd.desctype
and j.desctype='211') информация_про_материнскую_компанию,

c.userwork


from vaccount a, address ad, customer c, contact ct, priv_person pp, OUTER jurhistory j, customer_link cl, customer_link_type clt,  tax_registration tr
where acc='2600701223001'

and j.idcustomer=c.idcustomer
and c.idcustomer=a.idcustomer
and c.idcustomer=ad.idcustomer
and c.idcustomer=ct.idcustomer
and cl.linktype=clt.link_type
and pp.idcustomer=cl.idcustmaster
and cl.idcustslave=c.idcustomer
and c.idcustomer=tr.idcustomer