BOb,
I thought your idea of using the dbf() structure was great, but unfortunately in the SELECT statement it says it can't find the TMP file for either view. Presumably this is because VFP doesn't actually write a TMP file to disk when it can hold it in memory.

I'll keep trying in hopes I've simply got the syntax wrong somewhere.

Thanks,
Barbara

>Another thing to try:
>
>

>USE rv1 in 0  && Data shows correctly if I Browse it
>
>USE rv2 in 0  && Data shows correctly if I Browse it
>
>cRV1 = dbf('rv1')
>cRV2 = dbf('rv2')
>
>SELECT v1.*, v2.* from (cRV1) v1 ;
>   left outer join (cRV2) v2 on v1.IDField = v2.IDField ;
>   into cursor curTemp
>

>
>********************
>
>Just some ideas...
>
>BOb
>