Date: 07/06/05 (MySQL Communtiy)    Keywords: php

I'm trying to figure out if this is possible. I have two tables with a one-to-many relationship. Table one is Projects. Table two is Investigators. There may be more than one investigator on a project. I'm looking for a way to perform a query (probably using a join) so that, instead of having:

Project 1 | Investigator 1
Project 1 | Investigator 2

I could get something like:

Project 1 | Investigator 1 | Investigator 2

I'm using PHP to run the query.

I've fiddled around with basic join syntax, but I can't get beyond the first setup. Is it possible, or just a pipedream?

Source: http://www.livejournal.com/community/mysql/61230.html