Hi all, especially Steve

I was recently trying to save the following SQL code for a FireBird database in ViewEditor by Steve for VFP6

SELECT MSALESREPS.*, ;
		MSALESREPS_A.CNAME AS CSPONNAME, ;
		MSALESREPS_A.CCITY AS CSPONCITY, ;
		MSALESREPS_A.CCODE AS CSPONCODE ;
	FROM MSALESREPS MSALESREPS ;
		LEFT JOIN MSALESREPS MSALESREPS_A ;
				ON MSALESREPS.IPID = MSALESREPS_A.IID ;
	ORDER BY MSALESREPS.CNAME, MSALESREPS.CCITY

When saved the SQl defaults to

SELECT * ;
	FROM MSALESREPS MSALESREPS ;
	ORDER BY MSALESREPS.CNAME, MSALESREPS.CCITY

Why is it so?

Please advise.