Hi All,

I'm a SQL newbie, so please be gentle with me! We have a CRM system
with Potentials and Contacts, and my boss wants a report laid out with
one row per potential including contacts, the issue being that each
potential has zero or more contacts which are held in a separate table
linked by a contact-potential-relationship table, ! So I need to see
something like, potential name, amount, "contact list", notes, etc.
etc.

I searched the web and came across this solution in Oracle -
http://www.dba-oracle.com/t_display_..._same_rows.htm,
but I can't see how I can break the back of that solution to fit it
into MySQL. I also found a couple of solutions that required you to
know how many rows would be returned (how many contacts in my case),
but that's also not possible. There was also a solution that required
writing to a temporary table, but I have no experience of that, so I
got a bit lost. Any thoughts or help would be much appreciated.

TIA,

Russ,