Many thanks
--
Aeon McNulty
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. 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 on the list can help me.
Is there an easy and straightforward way way
?
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.value|C.value|
+---+---+---+
| a1 | b1 | c1 |
| a1
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 information. Could you post a 3
column-query
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', s.Subscription_Expiry_Date,
NULL))as 'ABS'
, MAX