OQL query for objects where reference is not empty.

1
Hi All, I want to create a OQL query for a table of products with a BaseMaterial. So where the Products without a reference BaseMaterial is not shown. I came to this: SELECT ProductName, BaseName FROM Sales.Product AS p join p/Sales.Product_BaseMaterial/Sales.BaseMaterial But now I want to leave out the products with an empty references to BaseMaterial but I don't know how. Can anyone help me out?
asked
1 answers
1

With empty reference, you mean Products that don't have an association to BaseMaterial?

How about adding

WHERE p.Product_BaseMaterial IS NOT NULL

 

answered