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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
