OQL query for objects where reference is not empty.

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?
1 answers

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

How about adding

WHERE p.Product_BaseMaterial IS NOT NULL