A
anna_717717
Hi All,
Hope someone can point me in the right direction.
I've got eight tables of part types. I need to create a query to show all
the possible combinations of how they can fit together. The possibilities are
restricted by the realtionships between the parts.
e.g table1.field1>table2.field8
table1.field1<table2.field9
table2.field4=table5.field2
Then I would need to filter the data based on customer requirements to
select the parts needed.
My ideal scenario would be to be able to ask the user to define the
relationships via a form and then choose which ones to apply to select the
records.
I tried using 1 query selecting the ID's from each of the tables using 4
subqueries to define the relationships for just 3 of the tables and it ground
to a halt! The number of records to be returned should have been >1million.
I would appreciate any help in how I should construct the query, and if
using subqueries is the right way to go.
Thanks
Hope someone can point me in the right direction.
I've got eight tables of part types. I need to create a query to show all
the possible combinations of how they can fit together. The possibilities are
restricted by the realtionships between the parts.
e.g table1.field1>table2.field8
table1.field1<table2.field9
table2.field4=table5.field2
Then I would need to filter the data based on customer requirements to
select the parts needed.
My ideal scenario would be to be able to ask the user to define the
relationships via a form and then choose which ones to apply to select the
records.
I tried using 1 query selecting the ID's from each of the tables using 4
subqueries to define the relationships for just 3 of the tables and it ground
to a halt! The number of records to be returned should have been >1million.
I would appreciate any help in how I should construct the query, and if
using subqueries is the right way to go.
Thanks