延长日期.sql

1.写出建立BORROW表的SQL语句

UPDATE BORROW
   SET RDATE=RDATE+7
SELECT CARD.CNO,BORROW.RDATE FROM CARD,BORROW
       WHERE      CARD.CNO=BORROW.CNO
              AND CARD.CNO IN
           (SELECT CNO FROM CARD 
            WHERE CLASS='C01')