延长日期.sql

来自「1.写出建立BORROW表的SQL语句」· SQL 代码 · 共 8 行

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')