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'
> , M
Yep, just what I needed.
SELECT
c.CompanyName
, MAX(IF(m.Member_Initials='ABS', s.Subscription_Expiry_Date,
NULL))as 'ABS'
, MAX(IF(m.Member_Initials='BV', s.Subscription_Expiry_Date,
NULL))as 'BV'
, MAX(IF(m.Member_Initials='CCS', s.Subscription_Expiry_Date,
NU
Hi Shawn
I hope this gives you what you need:
SELECT
member.Member_Initials,
company.Company_Name,
subscription.Subscription_Expiry_Date
FROM
subscription
INNER JOIN member
ON
member.Member_URN = subscription.Member_URN
INNER JOIN company
ON
company.Company_URN = subscription.Company_URN
>From
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 will actually produce from your data the information you would like
to have reformatted?
Column one needs to be your column names, column two nee
Hi Shawn
Yes, that's pretty much it. I'm impressed that you managed to work that out
from my previous email which was a bit thin on detail!
> Good news: For a specific case (when you know the number of columns) the
> query you seek to write follows a simple and predictable pattern and is
> not h
Hi David
Thanks your response. I'm using Lasso but that's largely unimportant because
I still need to get the data returned in a way that I can use it. I should
not have said "displaying" - I meant "returning".
I need to return only one column from table A (there could be up to 14
records). I nee
