Hello
 
This a a Paradox SQL question.
 
I want to create an SQL script that achieves the following:
 
Delete from LoggerPrice LP where (LP.Logger, LP.Forest, LP.Compartment, LP.Quality)
 not in
(select Dockets.Logger, Dockets.Forest, Dockets.Compartment, LogGrade.Quality
    from Dockets, LogGrade
    where Dockets.Grade = LogGrade.LogGrade)
 
So, I want to delete all of the records in LoggerPrice where the combination of Logger, Forest, Compartment and Quality is not present in the select statement.
 
This will not run. (Invalid use of Keyword)
 
Can someone enlighten me please?
 
TIA
 
Mark

Reply via email to