On May 8, 2008, at 12:36 PM, Redkins wrote:
> > 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. an outer join of Potential to Contacts is not enough? > 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. those are strange solutions which seem like overcomplex versions of joining a table to itself using an alias. I guess you want to have the Potential and multiple Contacts in a single row ? how many contacts ? what if there are 1800 contacts, you want a single row with many thousands of columns ? (that wont work, BTW) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
