-- kristian allikmaa
CREATE view accounts AS
SELECT c.companyid, c.compname, co.couname, c.street, c.zipcode, c.county, c.city, c.skype, c.ticker, c.uid, u.usrname as manager0, u.usrname as manager1, u2.usrname as manager2, c.emailstandard as email, c.c.comment1, c.telephone, c.telefax, c.web, cmp.typedesc, c.compsegmentid
FROM company c
LEFT OUTER JOIN country co on co.countryid = c.countryid
LEFT OUTER JOIN excuser u on u.userid = c.acctmgrid
LEFT OUTER JOIN excuser u2 on u2.userid = c.acctmgrid2
LEFT OUTER JOIN comptype cmp on cmp.comptypeid = c.comptypeid
WHERE c.isdeleted = ’n’
ORDER BY c.compname;