>>Take a look at readme.html on VFP installation cd, particulary at section 2.2. Language Element Issues ->> Left Outer Join returns zero records on nulls. It could be relevant to your situation.
>>
>>< SNIP >
>
>
>Thanks, but we are only doing joins on integer pids in the SQL statement in question. I looked at the section you referred me to and there didn't seem to be any applicability to this situation. Any other thoughts???

William,

Not so sure you can say that given the following, also in that paragraph: "Because there were several instances where SQL SELECT statements could return incorrect result sets in previous versions of Visual FoxPro, several changes were made in Visual FoxPro 7.0. You should verify that your SQL SELECT statements return expected result sets."

I interpret this as NOT relating only to JOINs.

Good luck