-
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.
-
I got it!!!
________
HERBALAIRE REVIEW
Last edited by sql; 03-06-2011 at 02:09 AM.
-
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
|
|