Subject | Re: [IBO] IBO Doesn't like this query |
---|---|
Author | Helen Borrie |
Post date | 2002-08-22T07:41:36Z |
At 12:18 AM 22-08-02 -0700, you wrote:
Is this the same as "all PRODUCTS that link to VENDORPRODUCTS rows where
cost is zero or NULL" ???
And as this is potentially a 1:Many situation, do you want to see output
for PRODUCTS where some VENDORPRODUCTS rows have zero or null and some
don't? Or is it just those where **all** VENDORPRODUCTS rows have zero or
none?
Helen
>Basically, I'm trying to find all PRODUCTS that don't link to a nonzero cost.{{{{ double-triple-negative}}}}
Is this the same as "all PRODUCTS that link to VENDORPRODUCTS rows where
cost is zero or NULL" ???
And as this is potentially a 1:Many situation, do you want to see output
for PRODUCTS where some VENDORPRODUCTS rows have zero or null and some
don't? Or is it just those where **all** VENDORPRODUCTS rows have zero or
none?
Helen