try

order by M.NYS_MODEL,N.MFG or (2,1)

eugene
OCP