actually I didn't notice
only need to

order by M.NYS_MODEL

because AND M.MFG = 'ATCCCC'
will stay the same anyways........

Eugene
OCP