Results 1 to 3 of 3

Thread: delete statement

Threaded View

  1. 03-08-2009, 09:45 PM #1
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421

    delete statement

    delete from Post as P, ApplyStatus as A
    where(Date(Current_Date)-Date(AccessTime))>=8
    and ReceiveAll=false
    and P.UserId=A.UserId;

    my ReceiveAll on ApplyStatus table , and my accessTime on post table, I want to delete the recode ReceiveAll=false, (Date(Current_Date)-Date(AccessTime))>=8
    ________
    Volvo B30 Engine Picture
    Last edited by sql; 03-06-2011 at 02:09 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules