Bill of Materials Option Interaction SQL Query

Hi All,

Just curious if anyone has ever created an SQL query to match up a Sales Order Line's selected bill options with any records in the BM_OptionInteractionHeader that would apply to that combination of selected options.  Trying to wrap my head around it.  While I understand the logic for WHEN an option interaction should match, I'm having a hard time translating the logic to T-SQL.  If anyone has done this before and can offer some example code it would be greatly appreciated.  Thanks!