Results 1 to 3 of 3

Thread: delete statement

  1. #1
    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.

  2. #2
    Join Date
    Jul 2003
    Posts
    421
    I got it!!!
    ________
    HERBALAIRE REVIEW
    Last edited by sql; 03-06-2011 at 02:09 AM.

  3. #3
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

Posting Permissions

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