select
distinct (full_name), short_name,
acc, codeokpo,
address,

(Select phone, fax, email from vaccount a, contact ct
where acc='2600500004001'
 and  ct.idcustomer=a.idcustomer),

(select  desctext from customer c, jurdesctype jd, vaccount a, jurhistory j
where acc='2600500004001'
 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='2600500004001'
 and  a.idcustomer=r.idcustomer)  as  risk_kod,

(select remark from spr_risk_kod srk, risk r, vaccount a
where acc='2600500004001'
 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='2600500004001'
 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,
customer_link cl,
customer_link_type clt,
tax_registration tr,
OUTER jurhistory j

where acc='2600500004001'

-- and  c.cstmr_type='Ю'
 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

(Select phone, fax, email from vaccount a left OUTER join contact ct on a.idcustomer=ct.idcustomer
where acc='2600500004001'),

Select ct.phone, fax, email from vaccount a, contact ct
where acc='2600500004001'
 and  ct.idcustomer=a.idcustomer
group by ct.idcustomer, ct.phone, ct.fax, ct.email

Select ct.phone, fax, email from vaccount a
left outer join contact ct on a.idcustomer=ct.idcustomer
where acc='2600500004001'
 and  ct.idcustomer=a.idcustomer
group by ct.idcustomer, ct.phone, ct.fax, ct.email

select
c.full_name, c.short_name,
a.acc, c.codeokpo,
ad.address,
ct.phone, ct.fax, ct.email from address ad, customer c, vaccount a Left Join contact ct on ct.idcustomer=a.idcustomer
where a.acc='2600500004001'
 and  c.idcustomer=a.idcustomer

select
distinct (c.full_name), c.short_name,
a.acc, c.codeokpo,
ad.address,
ct.phone, ct.fax, ct.email from  {address ad,}  customer c, vaccount a
Left Join contact ct on ct.idcustomer=a.idcustomer
left join address ad on ad.idcustomer=ct.idcustomer
where a.acc='2600500004001'
 and  c.idcustomer=a.idcustomer
-- and  a.idcustomer=ct.idcustomer

select
distinct (c.full_name), c.short_name,
a.acc, c.codeokpo,
address,
ct.phone, ct.fax, ct.email from  {address ad,}  customer c, vaccount a
Left Join contact ct on ct.idcustomer=a.idcustomer
left join address ad on ad.idcustomer=ct.idcustomer
where a.acc='2600500004001'
 and  c.idcustomer=a.idcustomer
-- and  a.idcustomer=ct.idcustomer