Re: [DUG-DB]: SQL problem

[Mark Howard]

Woops!  Sorry.  Ignore that last post - I've just found Carl Reynold's reply to a similar posting I made when I was last working on this problem, some months ago.   Can anyone recommend the best web site for lots of good examples of this sort of SQL code??   Mark ----- Original Message ----- From: Mark Howard To: Multiple recipients of list database Sent: Tuesday, October 24, 2000 3:34 PM Subject: [DUG-DB]: SQL problem 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