@LJ You might want to try something like this:

SELECT DISTINCT
	BUILTIN.DF( custitem5 ) || ' - ' || BUILTIN.DF( custitem6 ) AS Combo
FROM 
	Item 
WHERE 
	Parent = 1842
ORDER BY
	Combo

That will return the various combinations of the options for a given parent item. You'll need to change the two field names (custitem5, custitem6) with your instance's field names.

Thanks @tdietrich! I was trying to find any parent matrix items where the

itemoptions

field is empty, as this causes problems on our website i.e. the options don't appear on the product display page. We have thousands of parent items, and was hoping to find a quick way to identify these before our customers see the issue on the website.