Union three queries to show all results

[Former Member]

Hi

I have three queries that i'd like to package into one so that each result is displayed in a separate column. Any help would be much appreciated.

Separate queries are below

SELECT count (distinct T0.[CardCode])[MMS Professional Customers] FROM OCRD T0 WHERE T0.[QryGroup17] ='y'  and T0.[validFor] ='y'

SELECT count (distinct T0.[CardCode])[MMS Community Customers] FROM OCRD T0 WHERE T0.[QryGroup15] ='y'  and T0.[validFor] ='y'

SELECT count (distinct T0.[CardCode])[MMS Professional Customers] FROM OCRD T0 WHERE T0.[QryGroup17] ='y'  and T0.[validFor] ='y'

Cheers

Lisa

[Johan_H · Accepted solution]

Hi Lisa,

Please try this:

SELECT (SELECT count (distinct T0.[CardCode])[MMS Professional Customers] FROM OCRD T0 WHERE T0.[QryGroup17] ='y'  and T0.[validFor] ='y') AS Column1

,(SELECT count (distinct T0.[CardCode])[MMS Community Customers] FROM OCRD T0 WHERE T0.[QryGroup15] ='y'  and T0.[validFor] ='y') AS Column2

,(SELECT count (distinct T0.[CardCode])[MMS Professional Customers] FROM OCRD T0 WHERE T0.[QryGroup17] ='y'  and T0.[validFor] ='y') AS Column3

Of course you can rename the columns to something a little more descriptive.

Regards,

Johan

[Former Member · Accepted solution]

Thanks so much Johan, worked a treat!

[Former Member]

HI

This query should work

select (SELECT count(T0.[CardCode]) FROM OCRD T0 WHERE T0.[QryGroup17] ='y'  and T0.[validFor] ='y') as MMSProfessionalCustomers

SELECT count (distinct T0.[CardCode]) FROM OCRD T0 WHERE T0.[QryGroup15] ='y'  and T0.[validFor] ='y' ) as MMSCommunityCustomers

SELECT count (distinct T0.[CardCode]) FROM OCRD T0 WHERE T0.[QryGroup17] ='y'  and T0.[validFor] ='y') as MMSProfessionalCustomers

shachar

[Former Member]

Thanks Saado, appreciate the help