SELECT cf.cfname "Field Name",
cfo1.customvalue "PrimaryParent Option",
cfo2.customvalue "SecondaryChild Option"
FROM customfield cf, customfieldoption cfo1, customfieldoption cfo2
WHERE cfname = 'Instrument'
AND cf.id = cfo1.customfield AND cf.id = cfo2.customfield
AND cfo1.parentoptionid is null
AND cfo2.parentoptionid = cfo1.id