D
dk
this is probably obvious but i cant see the wood for the trees.
anyway, i have a query with three tables. table1 has unqiue primary key
(id) that is joined to table2 (the many side).
table1s unique primary key is also joined to table3 (again the many
side).
so my query is showing the following....
table1.id table1.data table2.id table2.link table2.value table3.id
table3.link table3.value
4 sample 7 4 10 9
4 50
4 sample 7 4 10 10 4
70
4 sample 6 4 5 9
4 50
4 sample 6 4 5 10
4 70
in this example table1 has only one record and both table2 and table3
have only two records. if i remove either table2 or table3 i get the
correct results but not with both together.
i want to show the following...
table1.id table1.data table2.id table2.link table2.value table3.id
table3.link table3.value
4 sample 7 4 10 9
4 50
4 sample 6 4 5 10 4
70
I dont want a join between table2 and table3 as im just interested in
the total value.
I suspect i could do this from the query using just table1 and table2
and use the dsum function and specify table3s.id as the criteria.
any help appreciated,,
anyway, i have a query with three tables. table1 has unqiue primary key
(id) that is joined to table2 (the many side).
table1s unique primary key is also joined to table3 (again the many
side).
so my query is showing the following....
table1.id table1.data table2.id table2.link table2.value table3.id
table3.link table3.value
4 sample 7 4 10 9
4 50
4 sample 7 4 10 10 4
70
4 sample 6 4 5 9
4 50
4 sample 6 4 5 10
4 70
in this example table1 has only one record and both table2 and table3
have only two records. if i remove either table2 or table3 i get the
correct results but not with both together.
i want to show the following...
table1.id table1.data table2.id table2.link table2.value table3.id
table3.link table3.value
4 sample 7 4 10 9
4 50
4 sample 6 4 5 10 4
70
I dont want a join between table2 and table3 as im just interested in
the total value.
I suspect i could do this from the query using just table1 and table2
and use the dsum function and specify table3s.id as the criteria.
any help appreciated,,