Re: Joining a result set from four (4) tables

Hi Aaron,

The query builder to generate joins that you mentioned is exactly what I 
am going to do doing this time. That is one of the reasons I have the 
generic field names for the primary and foreign key fields. Then I only 
have to pass the search criteria the table names and which direction I 
want to do the joins.

Thanks again for your help.

Regards

John T



Aaron Bono wrote:
> We all find ourselves in different situations and because of that, 
> what works for one person, doesn't work for another - so I 
> understand.  Good luck with the application and future queries.  Maybe 
> you can use the existing structure of your application to help create 
> a query builder so you can have it write a lot of your joins for you.  
> That should help avoid a lot of simply typos or mix-ups when hand 
> writing your queries.
>
> I am glad the queries worked for you.
>
> -Aaron