IOSY_Views_3_6

CREATE OR REPLACE VIEW StaffAndRent AS
SELECT S.sno, S.fname, S.lname, S.tel_no, S.bno,
       P.pno, P.street, P.city, P.TYPE, P.rooms, P.rent
FROM StaffVSHKL S, PropertyForRentVSHKL P
WHERE S.sno = P.sno;