SELECT * FROM products pr WHERE discontinued AND NOT EXISTS ( SELECT * FROM childtable ct WHERE ct.product = pr.product AND (stock > 0 OR onorder > 0))>I have a parent tale called products. One of the fields is discontinued.
>SELECT DISTINCT PRODUCT.ProductId,PRODUCT.ProdItem, PRODUCT.DESCRIPTION ; > FROM PRODUCT INNER JOIN ProdSize ; > ON PRODUCT.ProductId = ProdSize.PRODUCT ; > WHERE PRODUCT.discontinued = .T. ; > AND ProdSize.onorder = 0 ; > AND ProdSize.stock = 0 ; > ORDER BY ProdItem ; > INTO CURSOR ProductsNoItems >>
>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); > INTO cursor ProductsWithItems >>