SELECT DISTINCT MG.IDNO ,MG.LOANUMBER,MG.PERIOD ,MG.YEAR1 ,
MG.TX_DATE,MG.TY_DATE ,MG.ACCRUED ,MG.SACCRUED,
MG.OPENING,MG.PAYMENT ,MG.INTEREST,MG.REPAY,MG.CLOSING,
L.CUSTOMER,(MG.IDNO+''+MG.LOANUMBER) AS IDNOLOAN
FROM MGBALANCE MG
LEFT JOIN LOANS L
ON MG.IDNO=L.IDNO
WHERE MG.IDNO= @ZIDNO AND
CONVERT(NVARCHAR, MG.YEAR1) + Right('00' + Convert(varchar(10), MG.PERIOD), 2) BETWEEN @STAT AND @END
ORDER BY MG.IDNO,MG.LOANUMBER,CONVERT(NVARCHAR,MG.YEAR1) + Right('00' + Convert(varchar(10),MG.PERIOD), 2),TX_DATE
Have the above error message when I introduced the 'DISITNCT' syntax.
Please rectify the problem above.
Thanks
What I have tried:
Checked my earlier codes and the interner