|
View previous topic :: View next topic
|
| Author |
Message |
Shereen Samuel
New User
Joined: 11 Apr 2013
Posts: 1
Location: India
|
|
|
|
Hello,
I have two tables. Details given below:
| Code: |
EDA0TAA_REL_KEY
-----------------------
Type Column VALUE
CHAR(8) IIPANAM EDASTC3
CHAR(20) IIPARVA PERIOD
CHAR(80) NIPARLD 00092
CHAR(7) IDBSLUP I03546A
TIMESTMP DDBSLUT 2008-11-11-06.43.45.951237 |
| Code: |
EDASTC3_SESSION
----------------------------
Type Column Name VALUE
CHAR(40) SECURITY_TOKEN QUHYIONDL8709977
CHAR(7) USER_ID IN4061
TIMESTMP CREATE_TIMESTAMP 2011-09-09-17.14.47.671000 |
My requirement is to :
Delete the records from EDASTC3_SESSION table with a create time stamp older than XX days defined in the EDA0TAA_REL_KEY . ie) DELETE all rows in table EDASTC3_SESSION older than the number of days in table EDA0TAA_REL_KEY .
Here we can take XX as 92 days.
Could anyone please help to write a query to achieve the same?
Thanks
Code'd and subject de-capped |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Please don't try to draw attention to your question by using all capitals in the subject. The effect will usually be the opposite of what you want.
Please do use the Code tags and Preview to preserve spacing and ensure your question looks how you want it to before Submit. |
|
| Back to top |
|
|
|
|
