delete from Products p1 where p1.Discontinued = .t. and ;
P1.ProductId not in (SELECT DISTINCT PRODUCT.ProductId as ProdID ;
	FROM PRODUCT INNER JOIN ProdSize ;
	ON PRODUCT.ProductId = ProdSize.PRODUCT ;
	WHERE PRODUCT.discontinued = .T. ;
	AND (ProdSize.onorder != 0 ;
	or ProdSize.stock != 0)

>>>I have a parent tale called products. One of the fields is discontinued.
>>>
>>>I have a child table, that links to the parent products via the productid key field. The child table has both an onorder and a stock field, to store any items that are onorder or have stock in inventory.
>>>
>>>There is a one to many relationship with the child.
>>>