While both Quote Line Item and Order Product have a lookup fields to Product, no relationship name is shown in Workbench.
Further digging indicates a somewhat hidden PriceBookEntry object exists in between.
OK, but since we can't query down more than one level, is there any easy way to make a single SOQL query to list ALL Products with ALL Quote Line Items & ALL Order Products?
It seems like it would be a basic thing, but I am stumped. Schoolboy error?
For example - the following simply does not work, even though there are lookup fields from both OrderItem and QuoteLineItem to Product:
Select id, (Select id from OrderItems), (Select id from QuoteLineItems) FROM Product2