The light finally went off...

for each "section" I need to cross apply it to do what I want.

Example below:

SELECT

x.value('UnparsedName[1]', 'VARCHAR(20)') as Name

,l.value('@BusinessType', 'varchar(20)') as BusinessType

,CAST(CONVERT(varchar(20),l.query('HighBalanceAmount/text()')) as money) as HighBalanceAmount

FROM ScreeningXML myXML

CROSS APPLY xmlNode.nodes('/MORTGAGEDATA/BORROWER') E(x)

CROSS APPLY xmlNode.nodes('/MORTGAGEDATA/CREDITREPORT/MERGEDLIABILITY') M(l)