p2

DROP VIEW en_alquiler;
CREATE VIEW en_alquiler
   AS
   SELECT cu.uuid, c.label,cu.state
   FROM cloth c, clothunit cu, rent r, rent_cloth rc
   WHERE c.id=cu.cloth_id AND
         r.id=rc.rent_id AND
         rc.clothunit_id=cu.id AND
         cu.state='ARRENDED';
GO

SELECT * FROM en_alquiler;