SELECT s.stateID, s.state, s.stateFull, c.countryId, c.country FROM tbl_UT_States s INNER JOIN tbl_UT_Countries c ON s.countryId = c.countryId ORDER BY state FOR json path, include_null_values