mdr lolo

create view VMesRespFutures(num, type, datedeb, datefin, portdep, portarr,nombat,nbplaces,nbequi) as
     select a.numact, a.typeact, a.datedebut, a.datefin, a.depart, a.arrivee,b.nombat,b.nbplaces,(select count(*)as nbequi from equipage e where e.numact=a.numact and b.numbat=e.numbat)
     from activite a,adherent ad, chefdebord c, bateau b
     where a.numact=c.numact and b.numbat=c.numbat and c.numadh=ad.numadh and a.numact in (select numero from VActivitesFutures) and ad.nom=getpgusername()
     order by a.datedebut;