Hi Doug!

How can I specify an alias for a table name in the join condition? For example, I have a table called ORDERS that holds customer order information. There is a field in ORDERS called PICKUP_SITE and another called DELIVERY_SITE. These are foreign keys into my SITES table. How can I set up my cursor and/or relation objects so that the resulting join condition looks like this:
FROM Orders INNER JOIN Sites PUSite ON PUSite.Site = PICKUP_SITE;
INNER JOIN Sites DLSite ON DLSite.Site = DELIVERY_SITE

I tried several different things including setting the Alias2 of the relation object to include the alias name (like "Sites PUSite") but without much success.

Thanks much!
Alan Buch