SQL syntax errors?
From: Ray <raymondsee_at_home.com>
Date: 2000/05/26
Message-ID: <p_mX4.91810$R4.531391_at_news1.rdc1.nj.home.com>#1/1
Date: 2000/05/26
Message-ID: <p_mX4.91810$R4.531391_at_news1.rdc1.nj.home.com>#1/1
Hey all,
Can you tell me if there is any problems/errors in the following code? I am
trying to delete all credit card information from the CreditCard table that
are over 60days of the PayDate!
delete *
from CreditCard C, Requires R, Payment P
where R.CC#=C.CC# AND
AND SYSDATE >= P.PayDate + 60 DAYS
~
~
Thanks
RAy
Received on Fri May 26 2000 - 00:00:00 CEST