[RBASE-L] - Re: Finding Records in a table that violate the one-to-many relationship

[Lawrence Lustig]

> R>edit all from salestrans where plantno+custid+jobno not in (select
> plantno+custid+jobno from job)

The proper technique for this is:

EDIT * FROM SalesTrans WHERE NOT EXISTS +
  (SELECT * FROM Job WHERE +
     PlantNo = SalesTrans.PlantNo AND +
     CustID  = SalesTrans.CustID  AND +
     JobNo   = SalesTrans.JobNo)

Make sure that the most unique of the three columns in Job is indexed!
--
Larry