Re: Returning Column and Row Headings Like a Spreadsheet

2004-07-23 Thread Aeon McNulty
That's just perfect! Than you so much! -- Aeon McNulty On 23/7/04 8:50 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > Yep, just what I needed. > > SELECT > c.CompanyName > , MAX(IF(m.Member_Initials='ABS&#

Re: Returning Column and Row Headings Like a Spreadsheet

2004-07-23 Thread Aeon McNulty
>From member: ABS BV CCS DNV GL KR LR NK RINA RS CRS IRS Many thanks -- Aeon McNulty On 23/7/04 7:35 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > I will be more than happy to help you build a case-specific crosstab > report. I have almost enough inf

Re: Returning Column and Row Headings Like a Spreadsheet

2004-07-23 Thread Aeon McNulty
oes that give you enough information? Many thanks -- Aeon McNulty On 23/7/04 6:36 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > If I understand you correctly Basically you want to convert this query > output: > > +---+---+---+ > |A.value|B.

Re: Returning Column and Row Headings Like a Spreadsheet

2004-07-23 Thread Aeon McNulty
probably not explaining myself very well. Can you suggest anything? Many thanks -- Aeon McNulty On 23/7/04 5:39 pm, "David Brieck Jr." <[EMAIL PROTECTED]> wrote: > On Fri, 23 Jul 2004 17:30:21 +0100, Aeon McNulty > <[EMAIL PROTECTED]> wrote: >> Hi, I hope someone

mysql@lists.mysql.com

2004-07-23 Thread Aeon McNulty
Many thanks -- Aeon McNulty -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]