Hi
I think that the next should work:

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

>Hi all
>
>I have just successfully created remote view in VFP which updates the FireBird database with a single record and also generating a next PK.
>
>Successful Remote View code
>

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

>
>Now as soon as I joined this to itself the whole thing conked off giving null everywhere.
>
>

>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
>

>
>Please advise.
>
>
>Plus I also noticed that when I had saved this view from the VFP-View designer the updates work (in the original view) but if I modify it with Steve's ViewEditor 2 then even if no changes in the SQL, the view stops working.
>
>What may be difference in the saved view?