|
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
|
- [DUG-DB]: SQL Problem Darren J Gilbertson
- RE: [DUG-DB]: SQL Problem Max Renshaw-Fox
- Re: [DUG-DB]: SQL Problem Peter's Hotmail
- RE: [DUG-DB]: SQL Problem Max Renshaw-Fox
- Re: [DUG-DB]: SQL problem Mark Howard
- Re: [DUG-DB]: SQL problem Mark Howard
