General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only