Re: SQL syntax errors?
From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/26
Message-ID: <IbtX4.209716$Tn4.1866174_at_news1.rdc2.pa.home.com>#1/1
Date: 2000/05/26
Message-ID: <IbtX4.209716$Tn4.1866174_at_news1.rdc2.pa.home.com>#1/1
See below
-- Robert Fazio, Oracle DBA rfazio_at_home.com remove nospam from reply address http://24.8.218.197/ "Ray" <raymondsee_at_home.com> wrote in message news:p_mX4.91810$R4.531391_at_news1.rdc1.nj.home.com...Received on Fri May 26 2000 - 00:00:00 CEST
> 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
> P.Payment#=R.Payment#
> AND SYSDATE >= P.PayDate + 60 DAYS
Try this. delete from CreditCard C, Requires R, Payment P where R.CC#=C.CC# AND P.Payment#=R.Payment# AND SYSDATE >= (P.PayDate + 60 );
> ~
> ~
>
> Thanks
> RAy
>
>