I have a database with 2 tables that needs some data pruning. There is a list of meter in a table called 'TL'. I first need to select all items where the column 'SampleInterval' = 6000.
There is another table called 'TLData' where all of the data is stored for each meter. This has columns 'Timestamp', 'TLInstance' and 'Data'. I need to delete all records, where 'TLInstance' is within the list returned from the previous query and 'Timestamp' is older than 2 years.
ID - Name - SampleInterval - TLInstance
1 Test 6000 1000
ID - Timestamp - Data - TLInstance
1 '2010-8-10 6:00' 123 1000
Can anyone help with this?