Complex query

W

Wolfe

Hello,

I am trying to create a query that will join three tables together. the
main table will need to return one record based on user selection. The
problem is, the two joined tables could contain numerous records for the
one record on the main table. What I would like to do is have one field for
each one of the joined tables shown at the end of the main tables record.
Basically all the records for the joined table need to be combined into one
record. Something like this:

This is how it is returned now:

[Main Table Record] [Joined Table 1], [Joined Table 2]
[Main Table Record] [Joined Table 1], [Joined Table 2]
[Main Table Record] [Joined Table 1], [Joined Table 2]

This is how I would like it returned:

[Main Table Record] [Joined Table 1, Joined Table 1, Joined Table 1],
[Joined Table 2, Joined Table 2, Joined Table 2]

Is there any way to concatenate all the records from the joined tables into
one field so the main table still returns only one record?

Thanks,
WOLFE
 
Top