kristian allikmaa

-- kristian allikmaa
CREATE VIEW projects AS
SELECT gm.grpname, gm.grpid, gm.grpdesc, gs.grpsubname, gs.grpsubid, (select count(*) from grpmbr where grpmbr.grpsubid = gs.grpsubid and grpmbr.isdeleted = 'n' and grpmbr.isactive = 'y') as liikmeid
FROM grpsub gs
LEFT OUTER JOIN grpmain gm on gm.grpid = gs.grpid
WHERE gs.isdeleted = 'n' and gs.isactive = 'y'
ORDER BY gm.grpname;