• try this

    SELECT (

    select

    *,

    (

    select * from account a

    where a.business_id = b.business_id

    for xml path('account'), root('accounts'), type

    )

    from business b

    for xml path(''), root('Small_Business'),TYPE

    )

    FOR XML PATH('Business_Type'), ROOT('XMl')

    .