Hi All, I may be thinking about this in totally the wrong way, but let me explain what I'm trying to do. We have a CRM system and the boss wants a report of Potential sales and the Contacts related to them. The trick being, he wants one Potential per row, and a potential can have zero or more contacts.
I've searched the web, but I don't even really know how to describe what I want to do without being really long winded! I found one or two solutions but they were based on knowing how many rows you would return, in my case how many contacts. I found a great solution here (http://www.dba-oracle.com/ t_display_multiple_column_values_same_rows.htm), but it's based on Oracle and I'm using MySQL 5.1 and I can't see a MySQL equivalent. Any help or thoughts much appreciated. TIA Russ. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
