Hi Alan,

Your message was not clear that you were referring to Stonefield Reports. As I uderstand the question, you are trying to use complex join expressions in the 'fillrelationscollection' method on the Data Engine.

I.e. an outer join with an 'AND' clause - OR - a reference to an Alias.

Let's hope Doug has an answer.

HTH,

Ken




>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