>If you're using the same twice as if it was two tables, you should give this second instance of the table a different alias. If I understood well,
>
>select * from leads ;
> {left/full/right} join leads on Leads.iSourceKey=Source.iSourcePrimaryKey;
> ... join NOTES on Leads.iNoteKey = Notes.iNotePrimaryKey ;
> ... join source s2 on S2.iNoteKey = Notes.iNotePrimaryKey

Notes rather than Source, but yes, that's the problem and the solution. I guess VFP is clobbering the two instances of Notes.iNotePrimarykey. *Sigh* I overlooked something so simple(aliasing) that I've done before. Thanks.