set col_C = 'S'
(select col_A, col_B, col_C , MAX(col_D) from "THISTABLE"
group by col_A, col_B, col_C having MAX(col_D) < '19850101') as myData
where THISTABLE.col_A = '2607121497' and THISTABLE.col_B = mydata.col_B and THISTABLE.col_C = 'T'
Hi all.. if anyone has some input on this it would be great.... my hair is all gray beacuse of this!.. Here we're using Pervasiv SQL (but normal SQL should work fine)
All columns are strings and we have no Unique ID to work with :-(
The problem is that when I run this... it says X rows affect... if I run a test query, say:
select col_A, col_B, col_C from "THISTABLE" where col_C = 'T' and col_D < '19850101'
It does not seem to have written to the rows