>SELECT MSALESREPS_A.*, ; > MSALESREPS_B.CNAME AS CSPONNAME, ; > MSALESREPS_B.CCITY AS CSPONCITY, ; > MSALESREPS_B.CCODE AS CSPONCODE ; > FROM MSALESREPS MSALESREPS_A ; > LEFT JOIN MSALESREPS MSALESREPS_B ; > ON MSALESREPS_A.IPID = MSALESREPS_B.IID ; > ORDER BY MSALESREPS_A.CNAME, MSALESREPS_A.CCITY >Bingo that did it, it was an issue with same name alias