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
>
>USE rv2 in 0
>
>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
>