Hello all,


I have a database with projects and locations. A project can be in
more than one location. So the table looks like this.

1 Burundi
1 Oklahoma
2 Kansas
3 Brazil


What I want to create is a query that only lists the projectid once,
and then has another field that gets filled with all of the locations
for that project. Right now I return a row for each combination of
projectid with a location. I just need a column that is the
culmination of the locations. Can somebody point me in the right
direction?

Thanks
Josh

[dizzyBlonde]

Hi Josh
I think what you are getting is known as the cartesian product, i.e all possible combinations.
You need to put the word DISTINCT in your select statement.
Hope this helps.